Hi,

How can i list default values associated with tables?
in sql 2000
Advance thanks


jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

The INFORMATION_SCHEMA.COLUMNS view has a column in it named COLUMN_DEFAULT which contains the DEFAULT expression assigned to a table columnn, if any.

Jeff Mason
[email protected]

thanks,
I solved it.

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

How did you solve it? I'd really like to know.

Hi Richard,

I solved using this query

SELECT C_OBJ.NAME AS CONSTRAINT_NAME, COM.TEXT AS DESCRIPTION
FROM SYSOBJECTS C_OBJ, SYSOBJECTS T_OBJ, SYSCOMMENTS COM
WHERE T_OBJ.ID = C_OBJ.PARENT_OBJ
    AND C_OBJ.ID = COM.ID
    AND C_OBJ.XTYPE = 'D'
    AND T_OBJ.NAME='Your_tableName'

if you have any doubt in it, let me know
if u find some better query
please inform me also:)

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.