default value in SQL

  • Thread starter Thread starter Calvin Lai
  • Start date Start date
C

Calvin Lai

Hi all,

Does anyone know how to retrieve the default value set in Sql server in
ASP.Net? any help or guildence will be appreciated.

Calvin
 
Hi Calvin,

You will have to execute sql stored procedure
exec sp_columns 'tablename'
and check out COLUMN_DEF column.
 
Back
Top