Online Documentation for SQL Manager for MySQL

Managing columns


The Columns tab is intended for managing table columns.

 

Hint: This tab is selected by default upon opening Table Editor if the Always open the Columns tab option is enabled on the Tools | Table Editor page of the Environment Options dialog.

 

Double-click a column to open Column Editor for editing the column.

 

Right-click a column to display the context menu allowing you to create new, insert, edit, drop, duplicate the selected column, or reorder columns of the table. Using the menu you can also copy to clipboard or export the list of the table columns to any of supported formats.

 

Columns management tools are also available through the Navigation bar and toolbar of Table Editor.

 

Table Editor - Managing fields

 

 

The Table Columns list provides the following attributes of each column of the table:

Column Name

Column Type

Size

Precision

Not Null

Default

Description

 

For details see Columns.