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 quick house sale 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_nameNote: you cannot delete a system-defined database.To rename a user-defined database use :sp_renamedb old_database_name , new_database_nameFortunately 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 :mastertempdbmodelmsdbResource——————————————————————————————————————————————–If u have any query feel free to ask. If u like this post , rate & comment it.