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?
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='.'"