Online Documentation for SQL Manager for SQL server

Columns


Table columns are managed within the Columns tab of Table Editor.

 

 

Creating Columns

 

To create a new table column:

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the tab area and select the New Column context menu item, or press the Ins key;
  • define the column properties using the Column Editor dialog.

 

Editing Columns

 

To edit an existing table column:

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the row and select the Edit Column <column_name> context menu item, or simply double-click the column;
  • edit the column properties using the Column Editor dialog.

 

To change the order of table columns:

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the row and select the Reorder Columns <column_name> context menu item;
  • edit columns' order using the Reorder Columns dialog.

 

Dropping Columns

 

To drop a table column:

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the row and select the Drop Column <column_name> context menu item;
  • confirm dropping in the dialog window.