SYNONYM

SYNONYM is an alternative name for a table, view, sequence, procedure, stored function

The main advantage is that they provide

• Data independence
• Location transparency

This will create an alias name for the sales table

CREATE SYNONYM INVENTORY_DATA FOR SALES;

DROP SYNONYM NAME

DROP SYNONYM INVENTORY_DATA

Back To Top- Home - Category