Describe the new feature

Add ability to view table comments.

If the user creates a table with comments, the comments are not listed in the "Edit table definition" window.

Example:

Create table with comments:

CREATE TABLE "MyTable" (
ProgLangID INT NOT NULL UNIQUE, -- Programming language ID
SettingName TEXT NOT NULL DEFAULT 'DEFAULT', -- Settings name
SettingValue TEXT NOT NULL DEFAULT '' -- Settings value
);

Now look at the newly created table using "Edit table definition" .
Comment -- Programming language ID is not list in the window, and there's no option to add comments when adding a new field.
The only way to see that the table has comments is to look at the DB Schema.
Image
It's hard to read the comments there, and there's no edit capability.

Details on adding feature.

• Add column after the Foreign Key column called Comments.
• When user is editing an existing table, make the comment column a read-only column.
• When user is creating a new table, make the comment column a writable column.

Example: