Joel wrote:
Date: Thu, 4 Apr 2002 13:02:44 -0500
From: "Joel Firestone" <[EMAIL PROTECTED]> | Block Address
| Add to Address Book
Subject: ALTER Table
Reply-to: [EMAIL PROTECTED]
To: "SQL" <[EMAIL PROTECTED]>
Everyone:
Can you use ALTER Table to rename a table? I have a
table I have
named 'Debts'. I want to rename it to 'DebtsBak', and
then if a
script fails, name it back. If so, what is the correct
syntax?
TIA.
Joel F
----
Joel,
Yes it is possible to rename a table using the
following syntax:
sp_rename 'tablename}', 'newtablename'
Do the reverse depending upon whatever script it is
you want to run. Look into CFTRY.
---mark
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
