Editing Object Script - Columns - XML - MediaWiki Table (short)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 5: | Line 5: | ||
Select Project, Project Version, Object, Command "Generate Script" | Select Project, Project Version, Object, Command "Generate Script" | ||
− | Select "XML", and predefined | + | Select "XML", and predefined XSLT "MediaWiki Table (short)" |
===Generated Code (AdventureWorks)=== | ===Generated Code (AdventureWorks)=== | ||
Line 102: | Line 102: | ||
| (getdate()) | | (getdate()) | ||
|} | |} | ||
− | |||
− | |||
===Generated Code (dbscript)=== | ===Generated Code (dbscript)=== | ||
− | + | {| border="1" cellpadding="5" cellspacing="0" | |
− | |||
− | {| border="1" cellpadding="5" cellspacing="0 | ||
|- | |- | ||
| '''Table | | '''Table | ||
Line 117: | Line 113: | ||
− | {| border="1" cellpadding="5" cellspacing="0 | + | {| border="1" cellpadding="5" cellspacing="0" |
− | | | + | | Column |
− | + | | Data Type | |
− | | | + | | Nullable |
− | | | + | | Default |
− | | | ||
|- | |- | ||
Line 151: | Line 146: | ||
|- | |- | ||
| ID | | ID | ||
− | | | + | | varchar(50) |
| not null | | not null | ||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
|- | |- | ||
| DataType | | DataType | ||
− | | | + | | varchar(50) |
− | | null | + | | not null |
| | | | ||
|- | |- | ||
Line 186: | Line 176: | ||
|- | |- | ||
| CollationName | | CollationName | ||
− | | | + | | varchar(50) |
| null | | null | ||
| | | | ||
Line 206: | Line 196: | ||
|- | |- | ||
| Computed | | Computed | ||
− | | | + | | nvarchar(1000) |
| null | | null | ||
| | | | ||
Line 220: | Line 210: | ||
| (0) | | (0) | ||
|- | |- | ||
− | | | + | | XmlAttributes |
− | | nvarchar( | + | | nvarchar(1000) |
− | |||
− | |||
− | |||
− | |||
− | |||
| null | | null | ||
| | | | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| Description | | Description | ||
− | | | + | | nvarchar(1000) |
| null | | null | ||
| | | | ||
Line 246: | Line 226: | ||
|- | |- | ||
| DFName | | DFName | ||
− | | | + | | varchar(128) |
| null | | null | ||
| | | | ||
Line 254: | Line 234: | ||
| null | | null | ||
| | | | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| Created | | Created |