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