how do i rename a table? i tried making a copy of it (select * into copy from original), but it turns out that doesn't work either... =(The method for renaming objects depends on which database engine you are using.
-PatP|||In SQL 2000
Select * into newTable from OldTable
drop Table OldTable
Madhivanan|||in sql serversp_rename 'tablename' , 'newname'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment