34,838
社区成员




ALTER PROC ExistsTab(@T NVARCHAR(50))
AS
IF EXISTS (SELECT *
FROM dbo.sysobjects
WHERE id = Object_id(N'[dbo].[' + @T + ']')
AND Objectproperty(id, N'IsUserTable') = 1)
-- 删除表
EXEC('DROP TABLE [dbo].' + @t) --drop table 语法不支持变量
GO
exec ExistsTab 'a'