Why to get default value form syscomments??(ASE)
<FONT face=新宋体>Hi all,<BR><BR>In ASE ,I want to get column default value and the only way<BR>I could find is as blow:<BR>-----------------------<BR>SELECTtext<BR>FROMsyscomments<BR>WHEREid=(SELECTcdefault<BR> FROMsyscolumns<BR> WHEREid=object_id('YourTableName'ANDname='YourColName'))<BR>-------------------------<BR><BR>I know the column default value can be got directly in ASA.<BR><BR>1)Why the default value got form syscomments in stead ofgetting form a system tables directly in ASE,just like ASA?<BR>2)Is the value got form syscomments <STRONG>secure</STRONG>?<BR>3)Are there any other methods to get the value?<BR><BR>Thanks,<BR><BR>Best Regards,<BR>Ketti</FONT>
页:
[1]