Specifies the database with which you want to work.
use database_name
is the name of the database to open.
use pubs2 go
The current database is now pubs2.
Allowed with an archive database.
The use command must be executed before you can reference objects in a database.
use cannot be included in a stored procedure or a trigger.
sp_addalias adds an alias, which permits a user to use a database under another name to gain access to that database.
ANSI SQL – Compliance level: Transact-SQL extension.
If the database has a “guest” account, all users can use the database. If the database does not have a “guest” account, you must be a valid user in the database, have an alias in the database, or be a System Administrator or System Security Officer.
Commands create database, drop database
System procedures sp_addalias, sp_adduser, sp_modifylogin
