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....!!!
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!!!
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.