Tables
The provider models the data in Square as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider 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. |
| Customers | Create, update, delete, and query the available customers in Square. |
| InventoryChanges | Query historical physical counts and adjustments on inventory items. |
| 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.. |