Difference between revisions of "Object Script - Columns - XML - MediaWiki Table (short)"
(→Screenshot) |
(→Description) |
||
(4 intermediate revisions by the same user not shown) | |||
Line 5: | Line 5: | ||
Select Project, Project Version, Object, Command "Generate Script" | Select Project, Project Version, Object, Command "Generate Script" | ||
− | Select "XML", and predefined | + | Select "XML", and predefined XSL "MediaWiki Table (short)" |
− | ===Generated Code=== | + | ===Generated Code (AdventureWorks)=== |
− | {| 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 | ||
+ | | Person.Contact | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''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'' | ||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- | |- | ||
| '''Table | | '''Table | ||
Line 17: | Line 117: | ||
− | {| 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 50: | Line 151: | ||
|- | |- | ||
| ID | | ID | ||
− | | | + | | nvarchar(128) |
| not null | | not null | ||
+ | | | ||
+ | |- | ||
+ | | DataTypeSchema | ||
+ | | nvarchar(128) | ||
+ | | null | ||
| | | | ||
|- | |- | ||
| DataType | | DataType | ||
− | | | + | | nvarchar(128) |
− | | | + | | null |
| | | | ||
|- | |- | ||
Line 80: | Line 186: | ||
|- | |- | ||
| CollationName | | CollationName | ||
− | | | + | | nvarchar(128) |
| null | | null | ||
| | | | ||
Line 100: | Line 206: | ||
|- | |- | ||
| Computed | | Computed | ||
− | | | + | | ntext |
| null | | null | ||
| | | | ||
Line 114: | Line 220: | ||
| (0) | | (0) | ||
|- | |- | ||
− | | | + | | XmlSchema |
− | | nvarchar( | + | | nvarchar(128) |
| null | | null | ||
| | | | ||
+ | |- | ||
+ | | XmlCollection | ||
+ | | nvarchar(128) | ||
+ | | null | ||
+ | | | ||
+ | |- | ||
+ | | IsXmlDoc | ||
+ | | bit | ||
+ | | not null | ||
+ | | (0) | ||
|- | |- | ||
| Description | | Description | ||
− | | | + | | ntext |
| null | | null | ||
| | | | ||
Line 130: | Line 246: | ||
|- | |- | ||
| DFName | | DFName | ||
− | | | + | | nvarchar(128) |
| null | | null | ||
| | | | ||
Line 138: | Line 254: | ||
| null | | null | ||
| | | | ||
+ | |- | ||
+ | | DFIsSysNamed | ||
+ | | bit | ||
+ | | not null | ||
+ | | (0) | ||
|- | |- | ||
| Created | | Created |
Latest revision as of 19:26, 31 December 2008
Description[edit]
This page has been generated using dbscript
Select Project, Project Version, Object, Command "Generate Script"
Select "XML", and predefined XSL "MediaWiki Table (short)"
Generated Code (AdventureWorks)[edit]
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)[edit]
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()) |