Difference between revisions of "Object Script - Columns - XML - MediaWiki Table (short)"
(→Generated Code (dbscript)) |
(→Generated Code (dbscript)) |
||
Line 102: | Line 102: | ||
| (getdate()) | | (getdate()) | ||
|} | |} | ||
+ | |||
+ | |||
===Generated Code (dbscript)=== | ===Generated Code (dbscript)=== |
Revision as of 19:25, 31 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)
updated 31.Dec 08 to reflect latest changes
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)
updated 31.Dec 08 to reflect latest changes
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 | nvarchar(128) | not null | |
DataTypeSchema | nvarchar(128) | null | |
DataType | nvarchar(128) | null | |
Length | int | null | |
DecimalLength | int | null | |
Nullable | bit | not null | (0) |
IsIdentity | bit | not null | (0) |
CollationName | nvarchar(128) | null | |
IdentityStart | int | null | |
IdentityInc | int | null | |
IsRowGuidCol | bit | not null | (0) |
Computed | ntext | null | |
IsPersisted | bit | not null | (0) |
NotForRepl | bit | not null | (0) |
XmlSchema | nvarchar(128) | null | |
XmlCollection | nvarchar(128) | null | |
IsXmlDoc | bit | not null | (0) |
Description | ntext | null | |
DFID | int | null | |
DFName | nvarchar(128) | null | |
DFExpr | ntext | null | |
DFIsSysNamed | bit | not null | (0) |
Created | datetime | not null | (getdate()) |