SQL Server determines whether a database, table, stored procedure, function exists

--determine if the database existsif exists(Select *  fromsys.databaseswhereName= 'Database name')Drop Database [Database name]--determine if a table existsif exists(Select *  fromsysobjectswhereId= object_id(N'[table name]') and ObjectProperty(ID, N'isusertable')= 1)Drop Table [Table name]--determine if a stored procedure existsif exists(Select *  fromsysobjectswhereId= object_id(N'[Stored procedure name]') and ObjectProperty(ID, N'isprocedure')= 1)Drop procedure [Stored Procedure name]--determine if a function existsIF object_id(N'Name of function') is  not NULLDROP FUNCTIONDnt_split--determine if the database is open for full-text searchSelect Databaseproperty('Database name','isfulltextenabled')--determine if the full-text catalog existsSelect *  fromSysfulltextcatalogswhereName='Full-text catalog name'

SQL Server determines whether a database, table, stored procedure, function exists