contoh membuat database dan tabel pada sql server

create database db080010197

on (name= N'db080010197_data',
filename = N'd:\k081\db080010197.mdf')
log on (name= N'db080010197_log',
filename = N'd:\k081\db080010197.ldf')

use db080010197

create table departemen
(
    Departmentid varchar (5) primary key,
    Departmentnama varchar (55),
    Departmenthead varchar (25)
   
)


insert into departemen values ('0001','dep_perindustrian','')
insert into departemen values ('0002','dep_kepariwisataan','kuncoro')
insert into departemen values ('0003','dep_keuangan','sukarjana')
insert into departemen values ('0004','dep_perhutanan','supriono')
insert into departemen values ('0005','dep_kelautan','mega')