sql server : get default value of a column

sql sql-server sql-server-2005

You can do this (done a SELECT * just so you can see all the info available):

SELECT *FROM INFORMATION_SCHEMA.COLUMNSWHERE....

This includes a "COLUMN_DEFAULT" column in the resultset.

sql sql-server sql-server-2005

Use

Select * From INFORMATION_SCHEMA.COLUMNS

there is a column called COLUMN_DEFAULT

sql sql-server sql-server-2005

The property you want is called "cdefault".

CodeHunter