Following is the full syntax used for creating database in Sql Server 2005.

——————————————————————————————————————————————-

CREATE DATABASE database_name

[ ON [ PRIMARY ]  [ <  filespec >] ]

{ LOG ON [ < filespec > ] ]

< filespec > : : =

( [ NAME = logical_file_name , ]

FILENAME = ‘os_file_name’

[ , SIZE = size ]

[ , MAXSIZE = { max_size | UNLIMITED } ]

[ , FILEGROWTH = growth_increment ] ) [ ,.... n ]

Description ::-

ON specifies the disk file used to store the data portion of the database.

LOG ON specifies the disk files used to store log files.

FILENAME=os_file_name specifies the operating-system file name for the file.

PRIMARY specifies the associated <filespec> list that defines files in the primary filegroup.

NAME=logical_file_name specifies the logical name for the file.

MAXSIZE=max_size specifies the maxium size to which the file defined in the <filespec> list can grow.

FILEGROWTH=growth_increment specifies the growth increment of the file defined in the <filespec> list.

Remember – ” FILEGROWTH setting for a file cannot exceed the MAXSIZE setting”

NOTE : Everything written between [ ] is optional .

But remeber that to create a database you must be a member of the dbcreator server role.

After a database is created, to check details of the database use following command :

sp_helpdb [ database_name ]

To drop a user defined database use following command:

DROP DATABASE database_name

Note: you cannot delete a system-defined database.

To rename a user-defined database use :

sp_renamedb old_database_name , new_database_name

Fortunately you can also create a database by a right click on the object explorer, Thanks to SQL SERVER Management studio 2005.

SQL SERVER 2005 contains the following system database :

master
tempdb
model
msdb
Resource

——————————————————————————————————————————————–

If u have any query feel free to ask. If u like this post , rate & comment it.

Regards,

Anuj Tripathi

Related posts:

1. How to Create A Microsoft Excel Database The term Microsoft Excel Database has never really sat very...
2. What is Firebird Sql Server Database. Database Administration Tools Firebird SQL is a open source database server based on...
3. Creating Sql Database Connection in Asp.net Web Application Through C# 1: Open visual studio 2005 and from FILE select NEW->...
4. Processes Database And Effective Database Management From small companies to leading corporate houses, every organization invests...
5. Ms Sql Database Repair Software Recovery Toolbox for SQL Server is an efficient way to...

Related posts brought to you by Yet Another Related Posts Plugin.