d365fo_get_table_info
Retrieve detailed table metadata including columns, keys, indexes, statistics, sample data, and relationships to explore tables before writing queries.
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 |
|---|---|---|---|
| profile | No | default | |
| table_name | Yes | ||
| include_sample_data | No | ||
| include_relationships | No |