SELECT
*
FROM sys.all_objects
WHERE type
IN (
'
P
',
'
TR
',
'
V
')
ORDER
BY modify_date
desc
EXEC [ sp_MSforeachtable ] ' ALTER TABLE ? CHECK CONSTRAINT ALL '
EXEC [ sp_MSforeachtable ] ' ALTER TABLE ? ENABLE TRIGGER ALL '
EXEC [ sp_MSforeachtable ] ' ALTER TABLE ? CHECK CONSTRAINT ALL '
EXEC [ sp_MSforeachtable ] ' ALTER TABLE ? ENABLE TRIGGER ALL '
欢迎加入技术分享群:238916811