CODEWITHSUNDEEP
mysqldatabasedatabase-designmysql-workbenchdatabase-schema
Virtrel
Virtrel

Reputation: 73

What does the column flag "G" in MySQL Workbench mean

See the image below, but as part of the table editor, there's column flags such as PK (primary key), NN (not null) and so on. The last one is 'G' MySQL table editor image

Upvotes: 6

Views: 2384

Answers (1)

gabe3886
gabe3886

Reputation: 4265

Having looked through some of the Workbench code and the MySQL documentation, it looks like the G column is for Generated Columns.

In the source code, there's the following within the mysql_table_editor_column_page file (line 132 at the time of writing):

model->model().append_check_column(MySQLTableColumnsListBE::IsGenerated, "G", EDITABLE);

Other code in the same area gives the layout consistent with what you're seeing in the visual for PK, NN etc., which is viewable in the source.

Upvotes: 4

Related Questions