Why to get default value form syscomments??(ASE)

kettijyy

免费乐捐，感谢支持

Hi all,

In ASE ,I want to get column default value and the only way
I could find is as blow:
-----------------------
SELECT text
FROM syscomments
WHERE id = (SELECT cdefault
FROM syscolumns
WHERE id = object_id('YourTableName' AND name = 'YourColName'))
-------------------------

I know the column default value can be got directly in ASA.

1)Why the default value got form syscomments in stead of getting form a system tables directly in ASE,just like ASA?
2)Is the value got form syscomments secure?
3)Are there any other methods to get the value?

Thanks,

Best Regards,
Ketti