Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Simplest Way To Create New Databases

By: FYIcenter.com

(Continued from previous topic...)

What is the simplest way to create a new database?

The simplest way to create a new database is to use the "CREATE DATABASE" statement with this syntax:

CREATE DATABASE database_name

For example, run this statement:

CREATE DATABASE FyiCenterData
GO

A new database called "FyiCenterData" should be created in the SQL server. Of course, FyiCenterData should be empty at this moment - no tables. But it should have some other data objects automatically created by the server.

(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?