Re: drop

[Christian Mack]

Stephen Uczekaj wrote:
> 
> Does anyone know if there is a drop statement which would allow one to remove
> tables starting with a substring.
> 
> For example:
> 
> if I have tables mytable, yourtable, mytable_contacts, yourtable_contacts;
> how would I drop just mytable and mytable_contacts?
> 
> thanks in advance,
> steve u.

Hi Steve

No, this isn't allowed in standard SQL.
Table and columnnames have to be constants in every query.

So you have to DROP them one by one.

Tschau
Christian