Object Script - Columns - XML - MediaWiki Table DocGen
Description
This page has been generated using dbscript
Select Project, Project Version, Object, Command "Generate Script"
Select "XML", and predefined XSL "MediaWiki Table DocGen"
Generated Code (AdventureWorks)
Table | Person.Contact |
Column | Data Type | Nullable | Default | PK | Index |
ContactID | int | not null | PK_Contact_ContactID | ||
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 | IX_Contact_EmailAddress | ||
EmailPromotion | int | not null | ((0)) | ||
Phone | dbo.Phone | null | |||
PasswordHash | varchar(128) | not null | |||
PasswordSalt | varchar(10) | not null | |||
AdditionalContactInfo | xml | null | PXML_Contact_AddContact | ||
rowguid | uniqueidentifier | not null | (newid()) | AK_Contact_rowguid | |
ModifiedDate | datetime | not null | (getdate()) |
Detail Table | Column | Referencing Column |
Sales.ContactCreditCard | ContactID | ContactID |
HumanResources.Employee | ContactID | ContactID |
Sales.Individual | ContactID | ContactID |
Sales.SalesOrderHeader | ContactID | ContactID |
Sales.StoreContact | ContactID | ContactID |
Purchasing.VendorContact | ContactID | ContactID |
Generated Code (dbscript)
Table | dbo.Columns |
Column | Data Type | Nullable | Default | PK | Index |
OID | int | not null | PK_Columns | ||
Obj_OID | int | not null | IX_Columns_Obj | ||
ColN_OID | int | null | IX_Columns_ColN | ||
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()) |
Relation | Column | Referenced Column |
dbo.Object | Obj_OID | OID |
Detail Table | Column | Referencing Column |
dbo.Comparison_Column | OID | Col_OID_Ref |
dbo.Comparison_Column | OID | Col_OID_Diff |
dbo.Object_Column | OID | Col_OID |
dbo.Object_Column | OID | Col_OID_Ref |