Altering the name of a table

Can I use the alter table SQL statement to change the name of a table? ~Brad [EMAIL PROTECTED] (573) 474-2453 Box 9383 [Personal Web Site] [Business Web Site] www.bradwood.com www.midamericapc.com

Re: Altering the name of a table

Brad Can I use the alter table SQL statement to change the name of a table? No, but you can do CREATE TABLE b AS SELECT * FROM a (in some DBMS) DROP TABLE a which has the same effect. Nick __ Get Your Own Dedicated Windows