Show Emails
The SHOW EMAILS command returns a result set listing all email domain object in the Connect environment.
Syntax
show emails; |
Parameters
None.
Details
The command returns the following result set:
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
|
Column Name
|
Data Type
|
Description
|
| id | string | Unique identifier for each email domain object. |
| name | string | Email name used when the developer created the email object. |
| description | string | Notes a developer added to the email object. |
| as | string | Lists any parameters given when the developer created the email object. Examples include to and from addresses, email subject and body, and file attachments. Refer toCREATE EMAIL for exhaustive list. |
| created_by | string | Connect developer who created the email object. |
| created_instant | instant | Instant when a developer created the email object. |
| modified_by | string | Connect developer who last modified the email object. |
| modified_instant | instant | Instant when a developer last modified the email object. |
Examples
show emails;
select * from (show emails)
where “as” like ‘%upload orders%’;
