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.
The permission checks for use differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions diabled, you must be a valid, alias, or guest user, or, a user with own database privilege or use database privilege on the database. 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 have own database privilege or use database privilege on the database. |
Granular permissions disabled |
With granular permissions diabled, you must be a valid, alias, or guest user, or, a user with sa_role or sso_role. 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
