Tables
The driver models the data in Square as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC Driver for Square Tables
| Name | Description |
| Cards | Create, update, delete, and query the available Cards in Square. |
| CatalogCategories | Query the available catalog categories. |
| CatalogDiscounts | Query the available catalog discounts. |
| CatalogImages | Query the available catalog images. |
| CatalogItems | Query the available items. |
| CatalogItemVariations | Query the available item variations. |
| CatalogModifierLists | Query the available catalog modifier lists. |
| CatalogModifiers | Query the available catalog modifiers. |
| CatalogTaxes | Query the available catalog taxes. |
| CustomerGroups | Retrieves, creates, updates, deletes customer groups of a business. |
| Customers | Create, update, delete, and query the available customers in Square. |
| DeviceCodes | Creates and lists DeviceCode that can be used to login to a Square Terminal device to enter the connected terminal mode. |
| GiftCardActivities | Creates and lists gift card activities. |
| GiftCards | Lists, creates, and updates gift cards. |
| InventoryChanges | Query historical physical counts and adjustments on inventory items. |
| Invoices | Create, configure, and publish invoices for orders that were created. |
| PaymentLinks | Lists, Creates, Updates, Deletes payment links. |
| Refunds | Create and query the details for all Refunds initiated by a merchant or any of the mobile staff of the merchant during a date range. |
| Shifts | Create, update, delete, and query the available shifts in Square.. |
| Subscriptions | Create and manage subscriptions. |