外部キーもあわせて begin try while(exists(select 1 from information_schema.table_constraints where constraint_type='foreign key')) begin declare @sql nvarchar(2000) select top 1 @sql=('alter table ' + table_schema + '.[' + table_name + '] …

権限取得 sys.database_permissions select OBJECT_NAME(major_id),USER_NAME(grantee_principal_id),* from sys.database_permissions プロシージャソース取得 sys.sql_modules select OBJECT_NAME(object_id),definition,* from sys.sql_modules sqlcmdと…