MySQL Administrator :: 17.4 Editors

Show SQL command before applying changes toggles whether the MySQL Table Editor will show you the ALTER TABLE statement it is about to execute for confirmation when you click Apply Changes.

All columns Not Null per default determines whether the MySQL Table Editor will designate columns as being NOT NULL by default when creating new columns.

All integer columns unsigned per default sets whether integer columns are declared UNSIGNED by default when creating new columns.

PK Naming dictates the format that should be used to name PRIMARY KEY columns that are automatically generated. the %tablename% portion will be replaced with the name of the appropriate table.

Index Naming sets the name automatically generated for new indexes. The %nr% string will be replaced with an automatically incrementing number.

FK Naming configures the name used when creating new foreign keys.

PK Datatype is the datatype used when creating a PRIMARY KEY column.

Def. Datatype is the default datatype assigned to all new columns that are not part of a PRIMARY KEY.