This done by

exec sp_rename 'oldTableName' , 'newTableName'

There are two ways of renaming a table.
1. Create table NewTableName As Oldtablename.
(this query copies everything to new table except the constraits.)
2. Rename table NewTableName Oldtablename.
(This query simply renames the original table leaving all the data and constraints intact.

plz send me the detail of this coding
also the procedure

plz send me the detail of this coding
also the procedure

The SQL Query for rename the Table:

exec sp_rename 'oldTableName' 'newTableName'

OR

RENAME TABLE student TO student_new

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question