Set SQL Default Schema - SYSADM

Tags DARTS sql QUERY

This article provides information on how to set the default schema to SYSADM in SQL Developer.

Detailed Information

  • In the SQL Developer add:
    • ALTER SESSION SET CURRENT_SCHEMA = SYSADM;  
  • This code is helpful as the code from PS Query does not have the default schema.  This code sets all tables to the SYSADM, so the individual tables and views do not require the schema prefix.

Environment

  • SQL Developer
Print Article