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

From dbscript Online Help
Jump to: navigation, search
(→‎Description)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
 
 
===Description===
 
===Description===
  
Line 6: Line 5:
 
Select Project, Project Version, Object, Command "Generate Script"
 
Select Project, Project Version, Object, Command "Generate Script"
  
−
Select "XML", and predefined XSLT "MediaWiki Table (short)"
+
Select "XML", and predefined XSL "MediaWiki Table (short)"
  
−
===Generated Code===
+
===Generated Code (AdventureWorks)===
  
−
{| border="1" cellpadding="5" cellspacing="0"
+
''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 18: 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 47: 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 77: Line 186:
 
|-
 
|-
 
| CollationName
 
| CollationName
−
| varchar(50)
+
| nvarchar(128)
 
| null
 
| null
 
|  
 
|  
Line 97: Line 206:
 
|-
 
|-
 
| Computed
 
| Computed
−
| nvarchar(1000)
+
| ntext
 
| null
 
| null
 
|  
 
|  
Line 111: 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 127: Line 246:
 
|-
 
|-
 
| DFName
 
| DFName
−
| varchar(128)
+
| nvarchar(128)
 
| null
 
| null
 
|  
 
|  
Line 135: Line 254:
 
| null
 
| null
 
|  
 
|  
 +
|-
 +
| DFIsSysNamed
 +
| bit
 +
| not null
 +
| (0)
 
|-
 
|-
 
| Created
 
| Created
Line 143: Line 267:
  
 
===Screenshot===
 
===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"