Buat Database dengan SQL server 2008

Ini dia cara membuat Database,Alter dan Drop database :

1. Syntax Create Database

    CREATE DATABASE database_name

    

  [ ON < filespec > [ ,...n ] ]

  [ LOG ON { < filespec > [ ,...n ] } ]

 < filespec > ::=

  [ PRIMARY ]

  ( [ NAME = logical_file_name , ]

  FILENAME = 'os_file_name‘

  [ , SIZE = size ]

  [ , MAXSIZE = { max_size | UNLIMITED } ]

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

2. Syntax Alter Database & Drop Database

  ALTER DATABASE database_name

  { ADD FILE < filespec > [ ,...n ]

  | ADD LOG FILE < filespec > [ ,...n ]

  | REMOVE FILE logical_file_name

  | MODIFY FILE < filespec >

  | MODIFY NAME = new_dbname }

  Filespec ::=

  ( NAME = logical_file_name

   [ , NEWNAME = new_logical_name ]

   [ , FILENAME = 'os_file_name' ]

   [ , SIZE = size ]

   [ , MAXSIZE = { max_size | UNLIMITED } ]

   [ , FILEGROWTH = growth_increment ] ) 

}

DROP DATABASE database_name [ ,...n ]

Langsung Ke contoh :

CREATE DATABASE Sales

ON

  ( NAME = Sales_dat,

  FILENAME = 'C:\SQL Server Data\SaleDat.mdf',

  SIZE = 8,

  MAXSIZE = Unlimited,

  FILEGROWTH = 2 )

LOG ON

  ( NAME = 'Sales_log',

  FILENAME = 'C:\SQL Server Data\SaleLog.ldf',

  SIZE = 5,

  MAXSIZE = 50,

  FILEGROWTH = 1 )

ALTER DATABASE Sales

  ADD FILE

  (

  NAME = Test,

  FILENAME = 'C:\SQL Server Data\test.ldf',

  SIZE = 5MB,

  MAXSIZE = 100MB,

  FILEGROWTH = 5MB

)

DROP DATABASE Sales

Itu dia cara membuat Database,Alter database dan Drop database.

Terimakasih.