Sql Server - Table
Management
Rename
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';
List
- U stand for user table
select * from sys.all_objects where type = 'U';
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';
select * from sys.all_objects where type = 'U';