--Determine if the database existsif exists (SELECT * from Master.. sysdatabases where name=n ' library name ')print 'Exist' Elseprint ' notExist'
- -Determine if table exists if object_id (n ' table name ', n ' U ') is not null
print "exist '
< Span style= "color: #000000; line-height:1.5; Font-style:normal; Font-weight:normal; " >else
print ' not Exist '
- -to determine if a temporary table existsIf object_id (' tempdb.dbo. #临时table name ') is not Nullprint 'Exist'Elseprint ' notExist'
--Determine if the stored procedure existsif exists (SELECT * from dbo.sysobjects WHERE id = object_id (n ' Addbatchrecord ') and OBJECTPROPERTY (ID, n ' isprocedure ') = 1)print ' Exist 'Elseprint ' not Exist '
--Determine if the name of the view you want to create existsif exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ View name] ') and OBJECTPROPERTY (ID, N ' isview ') = 1)print ' Exist 'Elseprint ' not Exist '
SQL Server determines if XX exists