d365fo_get_database_schema
Retrieve comprehensive database schema information including tables, columns, indexes, and relationships to understand D365FO metadata structure for query development.
Instructions
Get comprehensive schema information for the D365FO metadata database.
This tool provides detailed information about:
All database tables and their structures
Column definitions with types and constraints
Indexes and their purposes
Foreign key relationships
Table statistics (row counts, sizes)
FTS5 virtual table information
Use this tool to understand the database structure before writing SQL queries.
Args: table_name: Optional. Get schema for a specific table only. If omitted, returns schema for all tables. include_statistics: Include table statistics like row counts and sizes. include_indexes: Include index information for tables. include_relationships: Include foreign key relationships between tables. profile: Configuration profile to use (optional - uses default profile if not specified)
Returns: Dictionary with database schema
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | No | ||
| include_statistics | No | ||
| include_indexes | No | ||
| include_relationships | No | ||
| profile | No | default |