Re: drop a table that has a period (.) in the name

Jon wrote:

> Somehow, somebody managed to create a table with a period in the name.
> I don't know how, but I'd like to break their fingers.
>
> I'd like to get rid of it, and I've tried all the quoting I can think
> of.
>
> schema."table.name"
> schema.table.name
> "table.name"
>
> and nothing works.
>
> Does anybody have any ideas as to how I might go about deleting this
> table?
>
> TIA
> -j

I think others have told you how to drop it so I'll provide the information on how to keep anyone from ever doing it again.

http://www.psoug.org/reference/ddl_trigger.html

Look at the example titled:
"DDL Trigger To Prevent Creating Objects That Whose Names Begin With The Letter 'X'"

a slight variation will stop it from happening again and even allow you to identify the offending party.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)