There is a hell and heaven difference between the concept of SQL SERVER 7.0 and SQL Server 2005. But the procedure for creating a database in SQL server 2005 in almost same as it was in the older versions of the software. As we know, a new database in SQL server can be created in at least two ways (a) Enterprise Manager (b) SQL Query. In SQL server 2005 everything is packed under SQL server management studio. That means the new name of our old Enterprise Manager is now “SQL Server Management Studio”.
Procedure for creating Database in SQL server 2005 – Installed in Windows Vista.
ADVERTISEMENTS:
Method -1
- Open SQL Server Management studio in Administrative mode.
- Connect to the SQL server
- Right click on the database folder and click on New database
- Now a popup windows will open. Enter your database username and click ok
- That’s All. Click on the plus icon of the database folder to check the newly created database.
Method -2
- Open SQL Server Management studio in Administrative mode.
- Connect to SQL server
- Click on the New Query option from the toolbar (Below the file menu)
- Now SQL query window will open.
- Enter create database “test1”. And then click on the Execute option from the toolbar.
Note : The command for creating a database in SQL server is create database “database name”. We can enter the database name as per your requirement and then we have to execute the command. It’s that simple. Actually yesterday I learned all these things about SQL Server 2005 and am interested in shared my experience. But it’s seems to be as simple as it was before. Thank you.
Related Information:
ADVERTISEMENTS:
How to delete a database in Microsoft SQL server 2005 ?
Generally we can delete a database in Microsoft SQL server 2005 in two ways (a) Direct way (b) SQL Query.
Method A
- Expand the database folder of the SQL server.
- Select the required database.
- Right Click on the database and then click Delete.
Method B
- Open SQL Query window for this click on the New Query option from the toolbar (Below the file menu)
- Enter drop database “Test”
- Execute the Query . For this find and click on the Execute option from the toolbar.
- Note that in the below message box you see a message like ‘Command(s) completed successfully‘
ADVERTISEMENTS:
Note : ‘Test’ is the name of my demo database. But you have to enter your own database name. Drop Database is the command for deleting a database in SQL server.