The following describes the code used in SQL to determine whether a variety of resources exist. For more information, see SQL functions and databases.
-- Whether the database exists if exists (select * from master .. sysdatabases where name = n' database name') print 'exists' elseprint 'not exists'
-- Determine whether the table name to be created exists if exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [table name] ') and OBJECTPROPERTY (id, n' isusertable') = 1) -- delete a table drop table [dbo]. [Table name] GO
-- Determine whether the temporary table to be created exists. If Object_Id ('tempdb. dbo. # test') Is Not NullBeginprint ', 'endelsebeginprint' does Not exist 'end
-- Determine whether the stored procedure name to be created exists if exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [stored procedure name] ') and OBJECTPROPERTY (id, n' IsProcedure') = 1) -- delete stored procedure drop procedure [dbo]. [stored procedure name] GO -- determines whether the view name to be created exists if exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [view name] ') and OBJECTPROPERTY (id, n' isview') = 1) -- delete a view drop view [dbo]. [view name] GO -- determines whether the function name to be created exists if exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [function name] ') and xtype in (n'fn', n'if', n'tf') -- delete the function drop function [dbo]. [function name] GOif col_length ('table name', 'column name') is nullprint 'does not exist 'select 1 from sysobjects where id in (select id from syscolumns where name = 'column name ') and name = 'table name'