d365fo_get_table_info
Retrieve detailed metadata for Dynamics 365 Finance & Operations database tables, including column definitions, constraints, indexes, statistics, and relationships to support query development and data exploration.
Instructions
Get detailed information about a specific database table including:
Column definitions with types, nullability, and defaults
Primary and foreign key constraints
Indexes and their characteristics
Table statistics (row count, size, last updated)
Sample data (first few rows)
Relationships to other tables
This tool is useful for exploring specific tables before writing queries.
Args: table_name: Name of the table to get information about (e.g., 'data_entities', 'public_entities', 'entity_properties'). include_sample_data: Include sample data from the table (first 5 rows). include_relationships: Include information about relationships to other tables. profile: Configuration profile to use (optional - uses default profile if not specified)
Returns: Dictionary with table information
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | ||
| include_sample_data | No | ||
| include_relationships | No | ||
| profile | No | default |