Categories
Database Development

Same name for a view and synonym in same schema

Scenario:

In a schema (sc1), there is a synonym with name syn1 for table t1. I created a view with name as sc1.syn1.

And it got created successfully without any conflict with synonym.

Synonymn (syn1) and view (sc1.syn1) pointing to same table t1.

But view has some subset of columns from t1.

So, I am thinking what will be the out of query

select * from sc1.syn1;

Will it access synonym first or view?

Leave a Reply

Your email address will not be published. Required fields are marked *