Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - "USE" - Setting the Current Database

By: FYIcenter.com

(Continued from previous topic...)

How to set the current database?

Once you are connected to the SQL Server, you should select a database to work with and set it as the current database using the "USE" statement with this syntax:

USE database_name

The following tutorial example shows you how to set "FyiCenterData" as the current database, and create a table in "FyiCenterData":

USE FyiCenterData
GO
Changed database context to 'FyiCenterData'.

CREATE TABLE Links (Name NVARCHAR(32))
GO

SELECT name, type_desc, create_date FROM sys.tables
GO
name    type_desc       create_date
Links   USER_TABLE      2007-05-19 23:05:43.700

(Continued on next topic...)

1. What is a database?
2. What is the simplest way to create a new database?
3. How to set the current database?
4. How to delete a database?
5. Why I am getting this error when dropping a database?
6. How to get a list all databases on the SQL server?
7. Where is my database stored on the hard disk?
8. How to create database with physical files specified?
9. How to rename databases?
10. Why I am getting this error when renaming a database?
11. What are database states?
12. How to set a database state to OFFLINE?
13. How to move database physical files?
14. How to set database to be READ_ONLY?
15. How to set database to be SINGLE_USER?
16. What are system databases?