摘要:
不多说,直接上脚本。DECLARE @allUserTables TABLE( Id INT IDENTITY(1,1) NOT NULL, tableName VARCHAR(200), tableId INT)INSERT INTO @allUserTables ( tableName,tableId ) SELECT name, object_id FROM sys.objects WHERE type='U' AND name <> 'dtproperties' AND name <> 'sysdiagrams'D 阅读全文