get_table_data
Retrieve sample rows from a SQL Server table using optional WHERE conditions, row limits, and offset paging to preview and inspect data.
Instructions
Get sample data from a table with optional filtering and limiting
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of rows to return (optional, defaults to 100) | |
| where | No | WHERE clause conditions (optional) | |
| offset | No | Number of rows to skip before returning results (optional, defaults to 0). Pair with limit to page through a table. Row order is not guaranteed without an ORDER BY, so pages may overlap or skip rows on tables without a clustered index. | |
| schema | No | Schema name (optional, defaults to dbo) | |
| database | No | Database name (optional) | |
| table_name | Yes | Name of the table |