get_table_columns
Retrieve column details like names, data types, and keys for a specific table in CData Sync to understand table structure for data synchronization and ETL processes.
Instructions
Get column details for a specific table including names, data types, and keys.
RETURNS: Array of column objects with name, type, nullable, and key information.
COMMON ERRORS:
"Table not found" - Use exact name from get_connection_tables
"Connection not found" - Verify connection name
"Access denied" - Check table permissions
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionName | Yes | Connection containing the table | |
| table | Yes | Table name using exact name from get_connection_tables (include schema if needed, e.g., 'dbo.Customers') | |
| workspaceId | No | Workspace ID to use for this operation. Overrides the default workspace. Use 'default' for the default workspace or a UUID for specific workspaces. |