Phrase Completion

dbForge SQL Complete suggests not only separate keywords and object names but entire code phrases.

Examples

  1. OUTER APPLY instead of APPLY and ORDER BY instead of ORDER are prompted in the SELECT query.

    Outer Apply

  2. The ON NULL attribute of a created scalar-valued function is prompted.

    ON NULL

  3. The ORDER BY statement is suggested in the SELECT statement when a user declares columns and aliases.

    ORDER BY

  4. The CREATE TYPE .. AS TABLE command suggests context-based prompts for data types and primary keys of server objects in the CREATE TYPE statement.

  5. The TRIGGER suggestion for DML and DDL triggers is supported.

    ENABLE TRIGGER