[thelist] SQL/ASP Rename or Copy Table?

Scott Dexter sgd at ti3.com
Tue Oct 10 16:10:29 CDT 2000


I'll say yes ... --there's a system stored procedure sp_rename --look it up
in your books online

and at the very least there's the good ole SELECT INTO:

Select * into tbNewTable from tbOldTable

sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Tab Alleman [mailto:talleman at autobex.com]
> 
> Is there a way to use SQL from an ASP script to either Rename 
> a table or
> Copy it (structure and data) to another table with a different name?
> 
> Please say yes




More information about the thelist mailing list