Object Script - Columns - XML - MediaWiki Table (short)

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)

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	varchar(50)	not null
DataType	varchar(50)	not null
Length	int	null
DecimalLength	int	null
Nullable	bit	not null	(0)
IsIdentity	bit	not null	(0)
CollationName	varchar(50)	null
IdentityStart	int	null
IdentityInc	int	null
IsRowGuidCol	bit	not null	(0)
Computed	nvarchar(1000)	null
IsPersisted	bit	not null	(0)
NotForRepl	bit	not null	(0)
XmlAttributes	nvarchar(1000)	null
Description	nvarchar(1000)	null
DFID	int	null
DFName	varchar(128)	null
DFExpr	ntext	null
Created	datetime	not null	(getdate())

Screenshot

Generate MediaWiki source - screenshot