![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.