Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE dropatable (@TableName varchar(100))
- AS BEGIN
- DECLARE @SQLSTMT varchar(100)
- SET @SQLSTMT= 'DROP TABLE' +'_'+ @TableName
- IF (EXISTS(
- SELECT TABLE_NAME
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_NAME = N'@TableName'))
- BEGIN
- DROP TABLE @TableName
- END
- END;
Add Comment
Please, Sign In to add comment