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

From dbscript Online Help

Contents 1 Description 2 Generated Code (AdventureWorks) 3 Generated Code (dbscript) 4 Screenshot

Description

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)

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())

Screenshot

Generate MediaWiki source - screenshot