MySQL Bugs: #99599: Use standard table editor for table templates

Bug #99599	Use standard table editor for table templates
Submitted:	16 May 2020 12:41	Modified:	15 Jun 2020 12:34
Reporter:	Brad Lanier	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	8.0.20	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	table editor, template, workbench

Description:
Current table templates in Workbench do not support many of the standard table characteristics that are able to be set/modifies with the table editor used elsewhere in Workbench. As an example, columns that are a core part of all tables in a database generally have a common set of indexes as well. Since index names are only unique to the table that they are created against and since their creation can be a part of the Create Table Statement, this capability should be an included part of table templates to make the template feature truly useful. Other examples include comments for columns, additional column flags, character sets, etc.  Also, new features to MySQL that are covered elsewhere within Workbench get overlooked when it comes to Table Templates (case in point, support for generated columns Bug #99558).

How to repeat:
See Description.

Suggested fix:
Recommend using the same table editor used elsewhere within Workbench for creating and editing Table Templates.

Hello Brad Lanier,

Thank you for the bug report and feedback.

Regards,
Ashwini Patil

Hello,

When we use a lot of column's comment, it'll be great to set column's comment in the table's templates ;-)

New feature !

Best regards,