Statements such as `alter table` should provide auto-completion of table names. ALTER is also not recognised as a auto-completion keyword, yet it does appear as a keyword after entering (turns blue).


As with the CREATE keyword which auto-completes table after it, ALTER should also auto-complete INDEX, SCHEMA, SEQUENCE, TABLE, USER and VIEW.

After ALTER TABLE the table list of the currently active schema should be present as well as schema names. Once the table name is populate following should auto-complete one of ADD COLUMN, ADD CONSTRAINT, ALTER COLUMN, DROP COLUMN, DROP CONSTRAINT, these of which should then follow completion by the column or constraint within the given table.

These and other DDL statements should be implement, another would be CREATE INDEX which presently INDEX is not a recognised keyword.