Take a table to specify the default value for a column

Method One: Use system stored procedure sp_columns get
Sp_columns table_name, @column_name = ColumnName Returns the column_def of the result set is the default value of the field
Example: Get u_test table ID field C1 default value
Sp_columns u_test, @column_name = C1

Method Two: Obtain by system table syscolumns and syscomments
The Cdefault column in the syscolumns table is the default value ID, and its value corresponds to the syscomments table ID, syscomments the value of the table text column, which is the default value of the corresponding default value ID
Cases:
Select B.text
From syscolumns a LEFT join syscomments B on a.cdefault=b.id
where object_name (a.id) = ' u_test ' and a.name= ' C1 '