If you want to determine if there is a table or stored procedure, or flip-flop, or the like. You can find it from the SYSOBJECTS table in the database. For example: To determine whether there is any table authors in the database PUBS, you can query:
Select * form pubs.dbo.sysObjects where name = 'authors' and xtype = 'u'
If you want to determine whether there is a stored procedure PR_SEL in the database PUBS, you can query:
Select * form pubs.dbo.sysobje3cts where name = 'pr_sel' ane xipe = 'p'
