Sql Server - Table

Rename

EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr'; 

List

• U stand for user table

select * from sys.all_objects where type = 'U';