Rename Database Table

Question

How can i rename by Database table in sql server 2008

Answer 1

for sql sever use sp_rename command
to rename your database table:)

Answer 2

u can rename a table by
RENAME TABLE oldname TO newname

Answer 3

that's not working with sql server 2008