SQL Server: Drop/Truncate Table/Procedure

方法1：

 

Drop Table:

 

             IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'users')

                    DROP TABLE users;

 

 

方法2：

 

IF EXISTS (SELECT * FROM sysobjects WHERE name='procName' and type='p')

             drop proc procName

GO

 

Object type. Can be one of the following values:

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

FN = Scalar function

IF = In-lined table-function

K = PRIMARY KEY or UNIQUE constraint

L = Log

P = Stored procedure

R = Rule

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

V = View

X = Extended stored procedure