{"id":1635,"date":"2019-04-13T11:31:18","date_gmt":"2019-04-13T04:31:18","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=1635"},"modified":"2021-04-29T11:50:26","modified_gmt":"2021-04-29T04:50:26","slug":"sql-server-create-database","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-create-database\/","title":{"rendered":"SQL Server CREATE DATABASE"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to create a new database in SQL Server using CREATE DATABASE<\/code> statement or SQL Server Management Studio.<\/p>\n\n\n\n

Creating a new database using the CREATE DATABASE statement #<\/a><\/h2>\n\n\n\n

The CREATE DATABASE<\/code> statement creates a new database. The following shows the minimal syntax of the CREATE DATABASE<\/code> statement:<\/p>\n\n\n

CREATE DATABASE database_name;<\/code><\/span><\/pre>\n\n\n
In this syntax, you specify the name of the database after the CREATE DATABASE<\/code> keyword.<\/p>\n\n\n\n
The database name must be unique within an instance of SQL Server. It must also comply with the SQL Server identifier’s rules. Typically, the database name has a maximum of 128 characters.<\/p>\n\n\n\n
The following statement creates a new database named TestDb<\/code>:<\/p>\n\n\n
CREATE<\/span> DATABASE<\/span> TestDb;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Once the statement executes successfully, you can view the newly created database in the Object Explorer<\/strong>. If the new database does not appear, you can click the Refresh<\/strong> button or press F5 keyboard to update the object list.<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
This statement lists all databases in the SQL Server:<\/p>\n\n\n
SELECT<\/span> \n    name<\/span>\nFROM<\/span> \n    master.sys.databases\nORDER<\/span> BY<\/span> \n    name<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"SQL<\/figure>\n\n\n\n
Or you can execute the stored procedure sp_databases<\/code>:<\/p>\n\n\n
EXEC sp_databases;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Creating a new database using SQL Server Management Studio #<\/a><\/h2>\n\n\n\n
First, right-click the Database<\/strong> and choose New Database…<\/strong> menu item.<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
Second, enter the name of the database e.g., SampleDb<\/strong> and click the OK<\/strong> button.<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
Third, view the newly created database from the Object Explorer:<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
In this tutorial, you have learned how to create a new database using SQL Server CREATE DATABASE<\/code> statement and SQL Server Management Studio.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t