Change the default schema/database.

From SQLZOO
Revision as of 13:21, 17 July 2012 by Connor (talk | contribs)
Jump to: navigation, search

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