Change the default schema/database. - Revision history

Connor at 13:35, 17 July 2012

2012-07-17T13:35:09Z

Connor at 13:21, 17 July 2012

2012-07-17T13:21:03Z

Connor: Created page with "Change the default schema/database.

schema:gisq

In many engines several independant databases may exist. Often each user has his..."

2012-07-17T13:17:21Z

Created page with "Change the default schema/database. <div class='ht'> <div class=params>schema:gisq</div> <div> In many engines several independant databases may exist. Often each user has his..."

New page

Change the default schema/database.
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
In many engines several independant databases may exist. Often each user has his or her own database.
This allows different users to use the same names for tables.
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-sqlite'></source>
<source lang='sql' class='def e-db2'></source>
<source lang='sql' class='def e-ingres'></source>
<source lang='sql' class='def e-access'>N/A. Access is a single user system.
</source>
<source lang='sql' class='def e-postgres'>\connect template1 - scott
</source>
<source lang='sql' class='def e-oracle'>ALTER SESSION SET CURRENT_SCHEMA = haggis
<source lang='sql' class='def e-sqlserver'>USE master
</source>
<source lang='sql' class='def e-mysql'>USE scott
</source>
<source lang='sql' class='def e-mimer'></source>
<source lang='sql' class='def e-sybase'></source>

<div class="ecomm e-postgres" style="display: none">The \ commands are not part of SQL, they may be entered in the psql interface to postgres. The given command connects to database "template1" as user "scott"..</div>
<div class="ecomm e-oracle" style="display: none">In Oracle this is called a "schema". The new schema is called haggis - it belongs to a user called haggis.</div>
<div class="ecomm e-sqlserver" style="display: none">The master database includes system tables, many of these are hidden from normal users. </div>
</div>
{{Users ref}}

@@ Line 17: / Line 17: @@
 </source>
 <source lang='sql' class='def e-oracle'>ALTER SESSION SET CURRENT_SCHEMA = haggis
 <source lang='sql' class='def e-sqlserver'>Use Master
 </source>

Change the default schema/database. - Revision history

Connor at 13:35, 17 July 2012

Connor at 13:21, 17 July 2012

Connor: Created page with "Change the default schema/database. schema:gisq In many engines several independant databases may exist. Often each user has his..."

Connor: Created page with "Change the default schema/database.

schema:gisq

In many engines several independant databases may exist. Often each user has his..."