sql server default 제약조건 조회SQL

DB의 default Constraint 가져오기

 

select con.[name] as constraint_name, schema_name(t.schema_id) + '.' + t.[name] as [table],

col.[name] as column_name,

con.[definition]

from sys.default_constraints con

left outer join sys.objects t

on con.parent_object_id = t.object_id

left outer join sys.all_columns col

on con.parent_column_id = col.column_id

and con.parent_object_id = col.object_id order by con.name

 

출처

https://dataedo.com/kb/query/sql-server/list-all-default-constraints-in-the-database