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.
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.
