Breaking News

Script For Database ( Create Database, Drop Database, Create Table, and Drop Table)


This is example from database FUJI.database has table.the name of table is IDENTITY,adn atributes of IDENTITY are NAMES, AGE and ADDRESS.

  • Script for create database 
CREATE DATABASE FUJI;

  •  Script for delete database
DROP DATABASE FUJI;

  • Script for create table
CREATE TABLE IDENTITY(
NAMES VARCHAR(50),
AGE INTEGER,
ADDRESS VARCHAR(100));

  • Script for delete table
DROP TABLE IDENTITY;

No comments