[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