2020. 1. 15. 16:36
SQL SERVER
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
'SQL SERVER' 카테고리의 다른 글
sql server 2012 Recommended Trace flag (0) | 2020.02.13 |
---|---|
Oracle Client 업그레이드 (0) | 2020.01.16 |
SQL SERVER Setup 실행시 오류발생 해결 (0) | 2019.12.26 |
Table Size 확인 쿼리 (0) | 2019.12.12 |
테이블 반환 함수 (0) | 2019.10.25 |