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
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
