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

From dbscript Online Help
Jump to: navigation, search
(New page: ''This page has been generated using dbscript'' ''Select Project, Project Version, Object, Command "Generate Script"'' ''Select "XML", and predefined XSLT "MediaWiki Table (short)"'' {...)
 
(→‎Description)
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
''This page has been generated using dbscript''
+
===Description===
  
−
''Select Project, Project Version, Object, Command "Generate Script"''
+
This page has been generated using dbscript
  
−
''Select "XML", and predefined XSLT "MediaWiki Table (short)"''
+
Select Project, Project Version, Object, Command "Generate Script"
  
 +
Select "XML", and predefined XSL "MediaWiki Table (short)"
  
−
{| border="1" cellpadding="5" cellspacing="0"
+
===Generated Code (AdventureWorks)===
 +
 
 +
''updated 31.Dec 08 to reflect latest changes''
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Person.Contact
 +
|-
 +
|}
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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''
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
 
| '''Table
 
| '''Table
Line 14: Line 117:
  
  
−
{| border="1" cellpadding="5" cellspacing="0"
+
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 
 
 
|-
 
|-
Line 43: Line 151:
 
|-
 
|-
 
| ID
 
| ID
−
| varchar(50)
+
| nvarchar(128)
 
| not null
 
| not null
 +
|
 +
|-
 +
| DataTypeSchema
 +
| nvarchar(128)
 +
| null
 
|  
 
|  
 
|-
 
|-
 
| DataType
 
| DataType
−
| varchar(50)
+
| nvarchar(128)
−
| not null
+
| null
 
|  
 
|  
 
|-
 
|-
Line 73: Line 186:
 
|-
 
|-
 
| CollationName
 
| CollationName
−
| varchar(50)
+
| nvarchar(128)
 
| null
 
| null
 
|  
 
|  
Line 93: Line 206:
 
|-
 
|-
 
| Computed
 
| Computed
−
| nvarchar(1000)
+
| ntext
 
| null
 
| null
 
|  
 
|  
Line 107: Line 220:
 
| (0)
 
| (0)
 
|-
 
|-
−
| XmlAttributes
+
| XmlSchema
−
| nvarchar(1000)
+
| nvarchar(128)
 
| null
 
| null
 
|  
 
|  
 +
|-
 +
| XmlCollection
 +
| nvarchar(128)
 +
| null
 +
|
 +
|-
 +
| IsXmlDoc
 +
| bit
 +
| not null
 +
| (0)
 
|-
 
|-
 
| Description
 
| Description
−
| nvarchar(1000)
+
| ntext
 
| null
 
| null
 
|  
 
|  
Line 123: Line 246:
 
|-
 
|-
 
| DFName
 
| DFName
−
| varchar(128)
+
| nvarchar(128)
 
| null
 
| null
 
|  
 
|  
Line 131: Line 254:
 
| null
 
| null
 
|  
 
|  
 +
|-
 +
| DFIsSysNamed
 +
| bit
 +
| not null
 +
| (0)
 
|-
 
|-
 
| Created
 
| Created
Line 137: Line 265:
 
| (getdate())
 
| (getdate())
 
|}
 
|}
 +
 +
===Screenshot===
 +
 +
[http://www.devio.at/images/dbs-screenshots/obj_script_wiki.png Generate MediaWiki source - screenshot]

Latest revision as of 19:26, 31 December 2008

Description[edit]

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)[edit]

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)[edit]

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[edit]

Generate MediaWiki source - screenshot

Retrieved from "http://dbshelp.devio.at/index.php?title=Object_Script_-_Columns_-_XML_-_MediaWiki_Table_(short)&oldid=161"