SET SCHEMA? 
Author Message
 SET SCHEMA?

Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)

I guess that SET SCHEMA should change the front of the search path, so
that it would change the schema reported by current_schema().  It would
be a simplified form of SET SEARCH_PATH.

--

Isle of Wight, UK                            
http://www.***.com/
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Praying always with all prayer and supplication in the
      Spirit, and watching thereunto with all perseverance
      and supplication for all saints."       Ephesians 6:18

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Tue, 01 Feb 2005 13:38:07 GMT
 SET SCHEMA?

Quote:
> Would it be useful to implement the SET SCHEMA command from SQL92? (I
> assume it's also in 99.)

> I guess that SET SCHEMA should change the front of the search path, so
> that it would change the schema reported by current_schema().  It would
> be a simplified form of SET SEARCH_PATH.

Hrm - it would be sort of silly to launch an all-new standards-compliant
schema support without it?

Chris

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Tue, 01 Feb 2005 13:42:39 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SET SCHEMA?

2. Set Schema problems

3. Setting Schema

4. Set schema="yourdb"

5. Cannot set SCHEMA in db2cli.ini

6. Setting schema

7. Set schema="yourdb"

8. set schema in visual explain...

9. db2 7.1/win2k - SET SCHEMA failure with JDBC

10. Set current-schema and granting

11. DateTimeFormat Schema setting

12. How to set a Schema programmatically for Xerces-j


 
Powered by phpBB® Forum Software