Welcome to the SQL 4 CDS wiki!

SQL 4 CDS is a tool for XrmToolBox, a plugin for SQL Server Management Studio (SSMS) and a reusable engine, all to allow users to interact with Microsoft Dataverse / Dynamics 365 databases using standard SQL syntax.

Note that it does not do any unsupported operations on the back-end SQL Server database. SQL 4 CDS does not touch, or even have access to, this database. All data access and changes are translated automatically to supported FetchXML and other appropriate requests.

General

• Features
• Installing
• Connecting

Supported SQL Syntax

• SELECT
• INSERT
• UPDATE
• DELETE
• EXEC
• EXECUTE AS/REVERT
• DECLARE/SET
• IF/WHILE/GOTO
• TRY/CATCH/THROW & RAISERROR
• Data Types
• Expressions
• Query Hints
• Temporary Tables
• Cursors
• Window Functions

Developers

• ADO.NET Provider