Check whether SQL data exists (whether data exists), whether tables, or stored procedures exist

Determine whether data exists

 
If exists (select * From hong_pageconfig where names = 'name') Begin print '1' endelse begin print '0' end
 

---------------
-- 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 null
Begin
Print 'exist'
End
Else
Begin
Print 'nonexistent'
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 a stored procedure
Drop procedure [DBO]. [stored procedure name]
Go