Re: alter table - query help

2002-04-11 Thread Jeremy Zawodny
On Tue, Apr 09, 2002 at 09:38:47AM -0500, Aman Raheja wrote: > I want to alter 50 tables, and for each the names start with the > string 'mak' Is there an SQL query, so that I can do the change in > one command. Nope. You need an outside programming language to do it. Jeremy -- Jeremy D. Zawo

alter table - query help

2002-04-09 Thread Aman Raheja
Hello everyone I want to alter 50 tables, and for each the names start with the string 'mak' Is there an SQL query, so that I can do the change in one command. I have tried using wildcards - they don't seem to work in SQL. Thanks in advance. Aman __