CODEWITHSUNDEEP
mysqlmysql-workbenchvarchar
Force Flow
Force Flow

Reputation: 724

MySQL Workbench - default datatype sizes

In MySQL Workbench, is there a way to set the default datatype sizes?

For example, whenever I select the VARCHAR datatype, it defaults to VARCHAR(45).

In most cases, I set the length to VARCHAR(255).

So, to save myself some extra effort, how would I set the default to VARCHAR(255)?

Upvotes: 6

Views: 2680

Answers (1)

Force Flow
Force Flow

Reputation: 724

In version 5.2.47:

File > Properties > "Model" tab. In the "Column defaults" section for the "column type" field, change the value to VARCHAR(255).

Upvotes: 7

Related Questions