Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: show me the current schema.

    Hi Colleagues,

    Somebody can say me how to know the current schema in my session.

    Thank you for advanced.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Surprisingly, it is contained in the CURRENT SCHEMA special register. Depending on the context, you can SELECT it (e.g. VALUES CURRENT SCHEMA) or assign its value to a variable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •