Just create a new connection (hit the green plus sign) and enter the schema name and password of the new default schema your DBA suggested. You can switch between your old schema and the new schema with the pull down menu at the top right end of your window.
How do I change a schema in SQL?
To change the schema of a table by using SQL Server Management Studio, in Object Explorer, right-click on the table and then click Design. Press F4 to open the Properties window. In the Schema box, select a new schema. ALTER SCHEMA uses a schema level lock.
Where is schema in SQL Developer?
- Right click on the connection you have created.
- Choose option Schema Browser to get the view of all schema in the drop down list along with the tables.
