How phrase auto-completion works in dbForge Studio for SQL Server

dbForge Studio suggests not only separate keywords and object names, but entire code phrases. The following code phrases are supported:

  • BULK INSERT
  • ORDER BY
  • ORDER GROUP
  • GROUP BY
  • PRIMARY KEY
  • BULK INSERT
  • ENABLE TRIGGER
  • DISABLE TRIGGER
  • END CONVERSATION
  • MOVE CONVERSATION
  • TRUNCATE TABLE
  • OUTER APPLY
  • PARTITION BY
  • FOREIGN KEY
  • NOT NULL
  • GET CONVERSATION GROUP
  • SEND ON CONVERSATION
  • APPLICATION ROLE
  • ASYMMETRIC KEY
  • SYMMETRIC KEY
  • XML SCHEMA
  • CONVERSATION TIMER
  • ON NULL
  • COLUMNSTORE INDEX
  • ON PARTITIONS
  • XML INDEX
  • PRIMARY XML INDEX
  • INNER JOIN
  • OUTER JOIN
  • CROSS JOIN

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