Applications and users can access Dynamics 365 metadata through the driver in the following ways:
- ODBC API functions: The driver supports standard ODBC functions that allow metadata retrieval through the API, without the need to write SQL queries. These functions include
SQLColumns, SQLForeignKeys, SQLPrimaryKeys, SQLTables, and more.
For a complete list of supported functions and detailed descriptions, see ODBC functions for metadata retrieval.
- Information schema: The Dynamics 365 metadata database follows the SQL-92 Information Schema standard. It contains system tables with details about available tables, columns, constraints, and relationships, all accessible through SQL queries.
For more information, see Information schema.