The SQL statement determines whether a specified database, table, field, or stored procedure exists.

Code directly. This is useful to everyone!

Code

-- Determine whether [testdb] exists
If exists (select 1 from Master .. sysdatabases where name = 'testdb ')
Print 'testdb exist'
Else
Print 'testdb does not exist'

-- Determine whether the table [testtb] exists
If exists (select * From testdb .. syscolumns where id = object_id ('testdb. DBO. testtb '))
Print 'table testtb exists'
Else
Print 'table testtb does not exist'

-- Determine whether the [name] field exists in the [testtb] Table of the [testdb] Data
If exists (select * From testdb .. syscolumns where id = object_id ('testdb. DBO. testtb') and name = 'name ')
Print 'field name exists'
Else
Print 'field name does not exist'
If exists (Select name from sysobjects where name = 'stored procedure name' and type = 'P ')
Drop proc stored procedure name