– 更精确的查询
SELECT
obj.name
FROM SysObjects obj
LEFT JOIN syscolumns col ON col.id = obj.id
WHERE obj.XType='U' AND col.name = 'CreateId'
ORDER BY obj.Name
--定义变量
DECLARE @strSql NVARCHAR(4000);
DECLARE @strWhere NVARCHAR(1000);
DECLARE @TableName NVARCHAR(100);
DECLARE @strDelete NVARCHAR(100);
SET @strWhere = ' Where createid = ''170010000'' '
SET @strDelete = 'DELETE FROM '
--定义游标
DECLARE contact_cursor CURSOR FOR
--检索当前数据库中所有的用户表
SELECT Name AS TableName FROM SysObjects Where XType='U' ORDER BY Name
--打开游标
OPEN contact_cursor
FETCH NEXT FROM contact_cursor
INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
--拼接SQL
SET @strSql = @strDelete + @TableName + @strWhere;
PRINT @strSql
--EXECUTE sp_executesql @strSql
FETCH NEXT FROM contact_cursor
INTO @TableName
END
--关闭释放游标
CLOSE contact_cursor
DEALLOCATE contact_cursor