Difference between Alias Table & Duplicate Table

Alias Table:

1. Its a mirror image of the Parent Table
2. We can't edit or modify Alias Table
3. When there is a need to avoid self-join or circular join
4. Changes made in Parent Table is automatically reflected in Alias table

Duplicate Table:

1. Its a Copy of the Parent Table
2. We can edit/modify/delete columns in Duplicate table
3. Changes made in Parent table are not reflected in Duplicate table
4. Used when there is a need to use few columns of Parent table.

Next Time ...