Online Documentation for SQL Administrator for SQL Server

Tables


The Tables section of the Database Explorer is used for managing tables in the selected database.

 

Use the context menu to:

Create create a new table

Edit edit the selected table(s)

Drop drop selected table(s)

  • rename the selected table
  • select top 1000 rows from the selected table
  • create the object copy on the same server
  • clone the object copy to another server

Print create and print the report

 

Tables

 

 

The list displays the existing database tables as a grid with the following columns: Schema, Name, Data Space, Partition Column, Number of Partitions, LOB Data Space, Replicated, Filetable, Memory-optimized, Durability, Change Tracking, Description. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

 

To open a Table in the Table Editor, double-click it in the grid. Alternatively, you can right-click the Table alias and select the Edit Table(s) context menu item.