Simplest Way To Create New Databases in SQL Server

Q

What is the simplest way to create a new database in SQL Server?

✍: FYIcenter.com

A

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.

 

Managing Databases and Physical Files in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-24, 476👍, 0💬