I created a SQL database table in Visual Studio 2013. I want to rename it but the name property is disabled. How can I change the table name?
In Server Explorer right click on Views and click New Query.
use this code to rename table:
EXEC sp_rename 'Table', 'NewName'
then click on Execute button.
after 5-30 seconds in server explorer click on refresh button.