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 adapter 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