Single Quotes around Table Name...

[scan2k]

I created a table named 'XYZ' and now I can't drop the table. I mistakenly included the single quotes in my create table statement. How do I DROP a table with single quotes around it? Thanks for your help....!!!

 

[SQLBill]

Try:

DROP TABLE ''XYZ''

Note that those are all single quotes.

-SQLBill

 

[SQLBill]

You could also drop it through Enterprise Manager.

-SQLBill

 

[scan2k]

Thanks for your response but this does not work. I tried single and double quotes before and after the table name and I cannot get the table to DROP. Help Help!!!

 

[scan2k]

Also, cannot drop using Enterprise Manager...it gives an error. Error near 'xyz'

 

[Pattycake245]

Try putting square brackets around the table name:

drop table ['xyz']

Tim

 

[vongrunt]

drop table ['blah']

 

[scan2k]

This is SQL 6.5 does this matter? The ['xyz'] method is not working...it yields a syntax error. Still puzzled....

 

[JayKusch]

Can you post your DROP Table code to see if we can see an issue w/ the syntax?

Thanks

J. Kusch

 

[donutman]

Well if all else fails and you're a brave sole, then try going into the sysobjects table and manually change the name of the table. Then try to drop it using the new name. If that doesn't work I'd change the name back to what it was originally in the sysobjects table.
-Karl

 

[donutman]

To reconfigure the server to allow updating the sysobjects table see

http://msdn.microsoft.com/library/d...ql_server_system_catalogs_are_required.3f.asp