As for renaming the table, that could depend on your DBMS as well. /charlie
-----Original Message----- From: Randy Adkins [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 22, 2001 7:38 AM To: SQL Subject: Re: Altering the name of a table I dopnt think so however you can use a series of statements to get the desired output. CREATE TABLE (with all the same fields) INSERT INTO (newtable) DROP TABLE ----- Original Message ----- From: "Brad Wood" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Saturday, December 22, 2001 5:17 AM Subject: 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 > [EMAIL PROTECTED] [EMAIL PROTECTED] > > "HV Y VR WNDRD WHT TH WRLD WLD B LK WTHT NY VWLS??" > > ~BRD WD > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
