down jacket moncler Create Database in Sql Server
 

,nike Woods on Course to Become the World’s Richest Sportsman_6918,down jacket moncler
Create Database in Sql Server 2005,asics tigers Coping With Dementia_1078, Database Statements
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 ]

[ ,abercrombie sweatshirt,canada goose down parka Feel the Magical Power of Cosmetic Dentistry_1315, MAXSIZE = UNLIMITED ]

[ ,asic gel shoes, 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