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
-
OUTER APPLY instead of APPLY and ORDER BY instead of ORDER are prompted in the SELECT query.
-
The ON NULL attribute of a created scalar-valued function is prompted.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
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?