Sunday, January 27, 2013

Creating Database

Creating Database Using Navigation

Open the management studio tool and connect to the required server. The below navigation explains us the creation of database by using navigation:

Right click on database selection menu---> Select new database---> Provide a name to database--->Click OK button---> Click refresh.

Creating Database Using Command

To create a database using command we can follow the below syntax:
Syntax: Create database <Database name>
Example: Create database Employee

Note: SQL language is not case sensitive

System stored procedure: The system stored procedure will be used to retrieve the structural details of a specified database. If we are not providing any database name, this command will returns the list of all databases in the current server.

Note: A maximum of 32767 databases can be created in installation of SQL server.

Recommend on Google



Popular Posts