Guest User

Untitled

a guest
Aug 19th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. CREATE PROCEDURE dropatable (@TableName varchar(100))
  2. AS BEGIN
  3. DECLARE @SQLSTMT varchar(100)
  4. SET @SQLSTMT= 'DROP TABLE' +'_'+ @TableName
  5. IF (EXISTS(
  6. SELECT TABLE_NAME
  7. FROM INFORMATION_SCHEMA.TABLES
  8. WHERE TABLE_NAME = N'@TableName'))
  9. BEGIN
  10. DROP TABLE @TableName
  11. END
  12. END;
Add Comment
Please, Sign In to add comment