xxxxxxxxxx
SELECT object_definition(default_object_id) AS definition
FROM sys.columns
WHERE name ='colname'
AND object_id = object_id('dbo.tablename')
xxxxxxxxxx
SELECT
TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'dbo' /* use this as it is */
AND TABLE_NAME = 'TableName' /* add your table name here */
AND COLUMN_NAME = 'Column_name'; /* add your column name here */
xxxxxxxxxx
SELECT COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_schema_name'
AND TABLE_NAME = 'your_table_name'
AND COLUMN_NAME = 'your_column_name';