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.
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.
|• drop||Stephen Uczekaj||2 Aug|
| • Re: drop||Christian Mack||3 Aug|