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
반응형