This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 262854 - [82cat] DDL statements in editor should provide auto-completion assistance
Summary: [82cat] DDL statements in editor should provide auto-completion assistance
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 8.2
Hardware: PC Mac OS X
: P3 normal (vote)
Assignee: Libor Fischmeistr
Depends on:
Reported: 2016-07-18 14:25 UTC by brettryan
Modified: 2016-07-18 14:25 UTC (History)
0 users

See Also:
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description brettryan 2016-07-18 14:25:11 UTC
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.