Microsoft.NET 2.0 Interview Question:

Explain How to rename a table using sql queries?

Submitted by: Administrator

exec sp_rename 'oldTableName' , 'newTableName'

Use server side for secure validation. Use client side for fast,user friendly validations.

Execute sp_rename 'oldtablename', 'newtableaname'

sp_rename OldTableName, NewTableName
Submitted by: Administrator