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

Last modified: October 1, 2024

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.

   

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