# SMSTemplates Return all your created SMS templates - Catalog: `Brevo` - Schema: `SMSTemplates` - Primary Keys: `id` This is a read-only table. The Sendinblue API may not support changing the data or the Invantive UniversalSQL driver for Sendinblue does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Sendinblue API. ## Table Columns The columns of the table `SMSTemplates` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `compliance_compliance_toggle` | `char` | | ☐ | US compliance is enabled. | | `compliance_organisation_prefix` | `varchar2` | | ☐ | A recognizable prefix will ensure your audience knows who you are. Recommended by the U.S. carriers. | | `compliance_stop_keyword` | `varchar2` | | ☐ | Instructions to unsubscribe from future communications. Must include STOP keyword. | | `createdAt` | `varchar2` | Creation Date | ☐ | Creation UTC date-time of the template (YYYY-MM-DDTHH:mm:ss.SSSZ) | | `encryption` | `char` | | ☐ | Enable Unicode encryption. | | `id` | `int64` | ID | ☐ | ID of the template | | `media_file_size` | `varchar2` | | ☐ | file size in bytes. | | `media_file` | `varchar2` | | ☐ | file name of the media. | | `media_url` | `varchar2` | | ☐ | URL of the image. | | `message` | `varchar2` | | ☐ | message content for the sms | | `name` | `varchar2` | Name | ☐ | Name of the template | | `short_url_enabled` | `char` | | ☐ | URL shortening is enabled | | `unicode_sms` | `char` | | ☐ | Support unicode characters in the sms. | | `updatedAt` | `varchar2` | | ☐ | Creation UTC date-time of the template (YYYY-MM-DDTHH:mm:ss.SSSZ) |