Rename Table not working for me

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

babuganesh2000 Hall of Fame Points: 3123 More actions · Answer 1

Try this out....

EXEC sp_rename 'bcp_ki_city', 'bcp_city'

Thanks,

Ganesh

Bob Bender Valued Member Points: 64 More actions · Answer 2

Thanks for the response..

What this was about was part of a simple script (or series of commands) that would just sort an existing table on a particular field.

Is there a way to do it without sending all the records to a temp table or new table with a sort and then renaming that one the old name.

That seems lame.

Please offer an example if you can.