Difference between revisions of "Change the default schema/database."

From SQLZOO
Jump to: navigation, search
(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...")
 
Line 17: Line 17:
 
</source>
 
</source>
 
<source lang='sql' class='def e-oracle'>ALTER SESSION SET CURRENT_SCHEMA = haggis
 
<source lang='sql' class='def e-oracle'>ALTER SESSION SET CURRENT_SCHEMA = haggis
<source lang='sql' class='def e-sqlserver'>USE master
+
<source lang='sql' class='def e-sqlserver'>Use Master
 
</source>
 
</source>
 
<source lang='sql' class='def e-mysql'>USE scott
 
<source lang='sql' class='def e-mysql'>USE scott

Revision as of 13:21, 17 July 2012

Change the default schema/database.

schema:gisq

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.

 
 
 
 
 
N/A. Access IS a single USER system.
\CONNECT template1 - scott
ALTER SESSION SET CURRENT_SCHEMA = haggis
<SOURCE lang='sql' class='def e-sqlserver'>USE Master
USE scott
 
 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense