perciapan kuiz psbd lab

kawan - kawan 04PHM Binus.. besok kan ada kuiz online lab psbd tu.. yiu kita belajar bareng.. ni ak kaci mini note buat diapal.. hehe..


Create Database
CREATE DATABASE database_name

Drop Database
DROP DATABASE database_name

Create Table
CREATE TABLE table_name
( field1_name datatype ( length ),
field2_name datatype ( length ),
field3_name datatype ( length ),
....
PRIMARY KEY ( field_name ),
FOREIGN KEY ( field_name ) REFERENCES table_name,
constraint [constraint_name] check (criteria)
)

Drop Table
DROP TABLE table_name

Create Index
CREATE INDEX "INDEX_NAME" ON "TABLE_NAME" (COLUMN_NAME)

Drop Index
DROP INDEX table_name.index_name


Create view
Create view view_name
[ ( column , .....) ]
As subquery
[ with check option]

Drop View
Drop view [nama view]

GRANT
GRANT ON TABLE “table_name”
to “user_public”

REVOKE
REVOKE ON TABLE “table_name”
from “user_public”


Insert Into
INSERT INTO table_name ( field1_name , field2_name , ...)VALUES ( value1 , value2 , ...)

Update
UPDATE table_nameSET field1_name = [new value]WHERE {condition}

Alter Table
ALTER TABLE table_name ADD column_name datatype
ALTER TABLE table_name DROP COLUMN column_name