get_table_data
Retrieve paginated data from SQL Server tables by specifying table name, page number, and page size for efficient data access and management.
Instructions
Get paginated data from a SQL Server table. Returns a specified page of records with pagination enforced.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | The name of the table to query (can include schema, e.g., 'dbo.Users') | |
| page | No | Page number (1-based). Defaults to 1. | |
| pageSize | No | Number of records per page. Must be between 1 and 1000. Defaults to 100. | |
| orderBy | No | Column name to order by. Defaults to first column if not specified. |