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 […]