Sqlserver determine whether an object exists

If   Exists ( Select * From Sysobjects Where [ Name ] = ' Table Name ' And Xtype = ' U ' )
Begin

-- Code

End

 

Determine whether the object exists. xtype indicates the corresponding type.

U is the parameter.

Type exists in 6.0, and xtype exists in 7.0:

Type
Object type. It can be one of the following values:
C = check Constraints
D = default value or default Constraint
F = foreign key constraint
Fn = scalar function
If = embedded table functions
K = primary key or unique constraint
L = Log
P = Stored Procedure
R = rule
Rf = copy and filter the Stored Procedure
S = system table
TF = table functions
Tr = trigger
U = User table
V = View
X = Extended Stored Procedure

Xtype
Object type. It can be one of the following object types:
C = check Constraints
D = default value or default Constraint
F = foreign key constraint
L = Log
Fn = scalar function
If = embedded table functions
P = Stored Procedure
PK = primary key constraint (type: K)
Rf = copy and filter the Stored Procedure
S = system table
TF = table functions
Tr = trigger
U = User table
Uq = unique constraint (type is K)
V = View
X = Extended Stored Procedure