Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: SQL Server DDL Generation - Defaults, Comments
Topic Summary: SQL Server DDL Generation
Created On: 5-Apr-2006 19:02
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 5-Apr-2006 19:02
User is offline View Users Profile Print this message


Jane Stevens

Posts: 17
Joined: 21-Feb-2006

How do you generate a system default for a TIMESTAMP column?  Do you use GET DATE in the Default Value column?  In DB2 we just click the flag System Default.  We need our audit columns CRT_S, LST_UPD_S on records to use the system time upon insert.

How do you generate database comments for SQL server?  I cannot get any comments to generate in the DDL.  In DB2 we have a form which allows us to insert a description and a d/base comment of length 254
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.