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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 my table problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-21 : 12:07:13
md writes "how to check whether tables in database exist or not. i have many tables begin with 'tr' followed by 'yymmdd' like 'tr010101' mean Jan 01, 2001 but not all dates for the whole month exist (like say missing on 4, 6, 14-19, 23,25,26,27).

I want to make a query to show all records for the month but first i must check whether the table exist or not. i'm appreciate for your help.

thank you."
   

- Advertisement -