Archive/ABAP
SAP ERP MS SQL Database 의 sp_bindefault
heedol
2020. 12. 19. 22:04
728x90
반응형
sp_bindefault
SETUSER '스키마'
SELECT T.name, A.name, B.name, B.type_desc,
'EXEC sp_bindefault '''+B.name+''', ''스키마.'+ T.name +'.'+A.name+''''
FROM sys.tables T
INNER JOIN sys.columns A ON T.object_id = A.object_id
INNER JOIN sys.objects B ON A.default_object_id = B.object_id
WHERE T.name IN ( 테이블명 )
728x90
반응형