Mark: It's in a DTS package. I'm bypassing CF altogether. Thanks.
Joel ----- Original Message ----- From: "Mark Warrick" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 10:07 AM Subject: RE: ALTER Table > 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/ > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
