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

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?