List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 3 1999 3:33pm
Subject:Re: drop
View as plain text  
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

Thread
dropStephen Uczekaj2 Aug
  • Re: dropChristian Mack3 Aug