Thunderstone Support Forums

I inadvertently created a table in my DB, and assigned the name '.' to it!!! That is, the name of the table is the single period character. (Ridiculous, I know...! It happened because I accidentally used a dot in the wrong place in the cpdb command. Oops!) Anyway, I suppose it's not doing any harm just being there, but I'd like to get rid of it. I can't figure out how to drop it, though. The command "DROP TABLE ." is syntactically incorrect. Any ideas?

Thanks

Double quote the name, e.g.

tsql
SQL 1> drop table ".";

If that doesn't work you can rename the table then drop it and cleanup the mess.

tsql -u _SYSTEM "update SYSTABLES set NAME='zzz' where NAME='.'"
tsql "drop table zzz"
tsql -u _SYSTEM "delete from SYSCOLUMNS where TBNAME='.'"
tsql -u _SYSTEM "delete from SYSPERMS where P_NAME='.'"
tsql -u _SYSTEM "delete from SYSSTATISTICS where Object='.'"

Thanks! All cleaned up!