Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-04 : 00:24:25
|
| Manohar writes "Dear Sir/MadamMy name is Manohar Rao N.V.S.I want a small help from you.In my application I want to check for the existance of Tables in the database I am using. I am using 5 tables to retrive data from database, I want to check for the existance of all the 5 tables in only one single query. One of the Parent table has a primary key and others have a reference.How can I do it." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-04 : 00:38:05
|
| select * from sysobjectswhere xtype='U'and name in('table1','table2','table3','table4','table5')you can also check for EXISTS BOL.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
|
|
|
Help regarding existance of tables in Database