CODEWITHSUNDEEP
mysqlmysql-workbench
Factor Three
Factor Three

Reputation: 2284

Column Input Greyed out in MySQL Workbench

I am using MySQL Workbench 6 CE to create some tables for a new schema I made.

When I create the new table, the application displays a tab which allows me to edit the table name (by default, the name is new_table), select the schema default, and add a comment for the table (though doing that seems to generate syntax errors in the generated SQL).

What it does not do is allow me to specify or configure any of the columns for the table. There is an entire column section that is completely greyed out.

I am logged in as root and root has all privileges for this schema.

Have I found a bug, or is there something special I need to do in order to allow column specification in a table???

Someone please advise...

UPDATE: Adding screenshot as requested...

Screenshot of greyed out inputs (schema redacted for nondisclosure reasons)

Upvotes: 13

Views: 14915

Answers (4)

Arun Prajapati
Arun Prajapati

Reputation: 281

You have to checked any key to enable the column name. please check PK,NN, UQ, B etc then column are ready to edit. enter image description here

enter image description here

Upvotes: 0

abhinaw kumar
abhinaw kumar

Reputation: 301

Click on the encircled double arrow

Click on the encircled double arrow

You will now be able to edit columns. Click on any column name, grey area will become editable now.

Upvotes: 27

Antonio
Antonio

Reputation: 31

I have had the same prb in MySQL Worbench 6.3.6. Here is the link to the solution. Or just drag down your Output Panel in short !

http://bugs.mysql.com/bug.php?id=79281

Upvotes: 3

Mike Lischke
Mike Lischke

Reputation: 53337

When you started creating a new table you can simply add columns by double clicking the empty placeholder row:

enter image description here

Upvotes: 6

Related Questions