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';

Powered by ComboStrap