UserAliases
Lists aliases, which are alternative email addresses for a user.
Table Specific Information
Select
To get a list of all the aliases for a user, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. Otherwise, the 本製品 will automatically use the Id of the first user from the Users table.
For example, the following query is processed server side by the Google Directory APIs:
SELECT * FROM Aliases
Insert
To insert an alias, the following columns are required: UserId and Alias.
INSERT INTO Aliases (UserId, Alias) VALUES ('12345', 'Alias')
Update
UPDATEs are not supported for this table.
Delete
To delete an alias, the following columns are required: UserId and Alias.
DELETE FROM Aliases WHERE Id = '12345' AND Alias = 'Alias'
Columns
Name | Type | ReadOnly | Description |
Alias [KEY] | String | False |
The alias email address. |
UserId | String | True |
Id of the user. |
PrimaryEmail | String | True |
PrimaryEmail of the user. |
ETag | String | True |
ETag of the resource. |