Difference between revisions of "Object Script - Columns - XML - MediaWiki Table (short)"
(→Generated Code (AdventureWorks)) |
(→Generated Code (dbscript)) |
||
Line 105: | Line 105: | ||
===Generated Code (dbscript)=== | ===Generated Code (dbscript)=== | ||
− | {| border="1" cellpadding="5" cellspacing="0" | + | ''updated 31.Dec 08 to reflect latest changes'' |
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- | |- | ||
| '''Table | | '''Table | ||
Line 113: | Line 115: | ||
− | {| border="1" cellpadding="5" cellspacing="0" | + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | | Column | + | |- style="background:silver" |
− | | Data Type | + | | '''Column |
− | | Nullable | + | | '''Data Type |
− | | Default | + | | '''Nullable |
+ | | '''Default | ||
|- | |- | ||
Line 146: | Line 149: | ||
|- | |- | ||
| ID | | ID | ||
− | | | + | | nvarchar(128) |
| not null | | not null | ||
+ | | | ||
+ | |- | ||
+ | | DataTypeSchema | ||
+ | | nvarchar(128) | ||
+ | | null | ||
| | | | ||
|- | |- | ||
| DataType | | DataType | ||
− | | | + | | nvarchar(128) |
− | | | + | | null |
| | | | ||
|- | |- | ||
Line 176: | Line 184: | ||
|- | |- | ||
| CollationName | | CollationName | ||
− | | | + | | nvarchar(128) |
| null | | null | ||
| | | | ||
Line 196: | Line 204: | ||
|- | |- | ||
| Computed | | Computed | ||
− | | | + | | ntext |
| null | | null | ||
| | | | ||
Line 210: | Line 218: | ||
| (0) | | (0) | ||
|- | |- | ||
− | | | + | | XmlSchema |
− | | nvarchar( | + | | nvarchar(128) |
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | XmlCollection | ||
+ | | nvarchar(128) | ||
| null | | null | ||
| | | | ||
+ | |- | ||
+ | | IsXmlDoc | ||
+ | | bit | ||
+ | | not null | ||
+ | | (0) | ||
|- | |- | ||
| Description | | Description | ||
− | | | + | | ntext |
| null | | null | ||
| | | | ||
Line 226: | Line 244: | ||
|- | |- | ||
| DFName | | DFName | ||
− | | | + | | nvarchar(128) |
| null | | null | ||
| | | | ||
Line 234: | Line 252: | ||
| null | | null | ||
| | | | ||
+ | |- | ||
+ | | DFIsSysNamed | ||
+ | | bit | ||
+ | | not null | ||
+ | | (0) | ||
|- | |- | ||
| Created | | Created |
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()) |