Difference between revisions of "Object Script - Columns - XML - MediaWiki Table (short)"
(→Screenshot) |
(→Generated Code) |
||
Line 7: | Line 7: | ||
Select "XML", and predefined XSLT "MediaWiki Table (short)" | Select "XML", and predefined XSLT "MediaWiki Table (short)" | ||
− | ===Generated Code=== | + | ===Generated Code (AdventureWorks)=== |
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" | ||
+ | |- | ||
+ | | '''Table | ||
+ | | Person.Contact | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" | ||
+ | | Column | ||
+ | | Data Type | ||
+ | | Nullable | ||
+ | | Default | ||
+ | |||
+ | |- | ||
+ | | ContactID | ||
+ | | int | ||
+ | | not null | ||
+ | | | ||
+ | |- | ||
+ | | NameStyle | ||
+ | | dbo.NameStyle | ||
+ | | not null | ||
+ | | ((0)) | ||
+ | |- | ||
+ | | Title | ||
+ | | nvarchar(8) | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | FirstName | ||
+ | | dbo.Name | ||
+ | | not null | ||
+ | | | ||
+ | |- | ||
+ | | MiddleName | ||
+ | | dbo.Name | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | LastName | ||
+ | | dbo.Name | ||
+ | | not null | ||
+ | | | ||
+ | |- | ||
+ | | Suffix | ||
+ | | nvarchar(10) | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | EmailAddress | ||
+ | | nvarchar(50) | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | EmailPromotion | ||
+ | | int | ||
+ | | not null | ||
+ | | ((0)) | ||
+ | |- | ||
+ | | Phone | ||
+ | | dbo.Phone | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | PasswordHash | ||
+ | | varchar(128) | ||
+ | | not null | ||
+ | | | ||
+ | |- | ||
+ | | PasswordSalt | ||
+ | | varchar(10) | ||
+ | | not null | ||
+ | | | ||
+ | |- | ||
+ | | AdditionalContactInfo | ||
+ | | xml | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | rowguid | ||
+ | | uniqueidentifier | ||
+ | | not null | ||
+ | | (newid()) | ||
+ | |- | ||
+ | | ModifiedDate | ||
+ | | datetime | ||
+ | | not null | ||
+ | | (getdate()) | ||
+ | |} | ||
+ | |||
+ | |||
+ | ===Generated Code (dbscript)=== | ||
{| border="1" cellpadding="5" cellspacing="0" | {| border="1" cellpadding="5" cellspacing="0" |
Revision as of 22:25, 7 December 2008
Description
This page has been generated using dbscript
Select Project, Project Version, Object, Command "Generate Script"
Select "XML", and predefined XSLT "MediaWiki Table (short)"
Generated Code (AdventureWorks)
Table | Person.Contact |
Column | Data Type | Nullable | Default |
ContactID | int | not null | |
NameStyle | dbo.NameStyle | not null | ((0)) |
Title | nvarchar(8) | null | |
FirstName | dbo.Name | not null | |
MiddleName | dbo.Name | null | |
LastName | dbo.Name | not null | |
Suffix | nvarchar(10) | null | |
EmailAddress | nvarchar(50) | null | |
EmailPromotion | int | not null | ((0)) |
Phone | dbo.Phone | null | |
PasswordHash | varchar(128) | not null | |
PasswordSalt | varchar(10) | not null | |
AdditionalContactInfo | xml | null | |
rowguid | uniqueidentifier | not null | (newid()) |
ModifiedDate | datetime | not null | (getdate()) |
Generated Code (dbscript)
Table | dbo.Columns |
Column | Data Type | Nullable | Default |
OID | int | not null | |
Obj_OID | int | not null | |
ColN_OID | int | null | |
ColID | int | not null | |
ColOrder | int | not null | |
ID | varchar(50) | not null | |
DataType | varchar(50) | not null | |
Length | int | null | |
DecimalLength | int | null | |
Nullable | bit | not null | (0) |
IsIdentity | bit | not null | (0) |
CollationName | varchar(50) | null | |
IdentityStart | int | null | |
IdentityInc | int | null | |
IsRowGuidCol | bit | not null | (0) |
Computed | nvarchar(1000) | null | |
IsPersisted | bit | not null | (0) |
NotForRepl | bit | not null | (0) |
XmlAttributes | nvarchar(1000) | null | |
Description | nvarchar(1000) | null | |
DFID | int | null | |
DFName | varchar(128) | null | |
DFExpr | ntext | null | |
Created | datetime | not null | (getdate()) |