テーブル名、カラム名からデフォルト制約名を取得するクエリ

gistfile1.sql

declare @table sysname = 'table_name';
declare @column sysname = 'column_name';

select
	sys.default_constraints.name, *
from sys.tables
	inner join sys.columns
		on sys.tables.object_id = sys.columns.object_id
	inner join sys.default_constraints
		on sys.tables.object_id = sys.default_constraints.parent_object_id and
			sys.columns.column_id = sys.default_constraints.parent_column_id
where
	sys.tables.type = 'U' and
	sys.tables.name = @table and
	sys.columns.name = @column and
	sys.default_constraints.type = 'D';