DEFINITIONS

Definitions More Info.
Definition ID955
TitleSQL
CategoryNOTES
DefinitionVarolan mevcut constraint icin create-add constraint script
Definition Descriptionhttps://stackoverflow.com/questions/6115451/how-to-generate-all-constraints-scripts


TEK TABLO ICIN KONSTRAINT OLUSTUR

SELECT
'ALTER TABLE '+ SCHEMA_NAME(schema_id) + '.' + OBJECT_NAME(parent_object_id) +
' ADD CONSTRAINT ' + dc.name + ' DEFAULT(' + definition
+ ') FOR ' + c.name
FROM sys.default_constraints dc
INNER JOIN sys.columns c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id
WHERE OBJECT_NAME(parent_object_id)='ALoginDB'


SELECT top 1
'ALTER TABLE '+ SCHEMA_NAME(schema_id) + '.' + OBJECT_NAME(parent_object_id) +
' ADD CONSTRAINT ' + dc.name + ' DEFAULT(' + definition
+ ') FOR ' + c.name
FROM sys.default_constraints dc
INNER JOIN sys.columns c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id
RecordBycunay
Record Date22-07-2019 18:41:48
Düzenle
Kopyala
Sil