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)  can't drop tabels with a query

Author  Topic  paul13 Starting Member 17 Posts Posted - 2001-06-05 : 05:56:37 i'm running SQL Server 6.5 on NT 4.0 when i try to drop a table from enterprise with the query: drop table rtt2189 i get the following message Cannot drop table 'rtt2189', becuase it does not exist in system catalog i can drop the table by right clicking on it in server manager and selecting 'DROP' what is this system catalog, and why aren't my tables in it I need to be able to drop these tables with queries, because I make about 3 a day, and want them to be dropped automatically. i don't think temporary tables will work becuase the tables are manipulates by various stored procedures, and must last through various functions and subs in my ASP pages. won't a temporary table self drop? Edited by - paul13 on 06/05/2001 06:00:54 Edited by - paul13 on 06/05/2001 06:35:20