Difference between revisions of "Object Script - Columns - XML - MediaWiki Table (short)"

From dbscript Online Help
Jump to: navigation, search
(Screenshot)
(Generated Code)
Line 7: Line 7:
 
Select "XML", and predefined XSLT "MediaWiki Table (short)"
 
Select "XML", and predefined XSLT "MediaWiki Table (short)"
  
===Generated Code===
+
===Generated Code (AdventureWorks)===
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0"
 +
|-
 +
| '''Table
 +
| Person.Contact
 +
|-
 +
|}
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0"
 +
| 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)===
  
 
{| border="1" cellpadding="5" cellspacing="0"
 
{| border="1" cellpadding="5" cellspacing="0"

Revision as of 22:25, 7 December 2008

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)

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