# SQL: Add an alias domain

!!! attention

	 Check out the lightweight on-premises email archiving software developed by iRedMail team: [Spider Email Archiver](https://spiderd.io/).

[TOC]

## What is an alias domain used for?

Let's say you have a mail domain `example.com` hosted on your iRedMail server,
if you add domain name `domain.ltd` as an alias domain of `example.com`, all
emails sent to `username@domain.ltd` will be delivered to user
`username@example.com`'s mailbox.

## Add alias domain with iRedAdmin-Pro

With iRedAdmin-Pro, you can simply add alias domain name in domain profile page,
under tab `Aliases`.

Screenshot:

![](./images/iredadmin/domain_profile_alias.png)

## How to add an alias domain with SQL commands

Adding alias domain is as simple as inserting one SQL record. Let's create two
alias domains (`alias-1.com`, `alias-2.com`) for the primary domain
`example.com` with SQL commands below (Note: we use MySQL for example, but
PostgreSQL uses exactly same `INSERT` commands):

```
-- Connect to `vmail` database.
sql> USE vmail;

-- Create alias domain `alias-1.com`
sql> INSERT INTO alias_domain (alias_domain, target_domain) VALUES ('alias-1.com', 'example.com');

-- Create alias domain `alias-2.com`
sql> INSERT INTO alias_domain (alias_domain, target_domain) VALUES ('alias-2.com', 'example.com');
```

That's all.

## See also

- [LDAP: Add an alias domain](./ldap.add.alias.domain.html)
