Creating Tables
Previous:
Planning a Database: An Example: -
Note: - In the syntax of the queries brackets [ ] denote optional value and the examples are based upon the database in the previous section.
CREATE TABLE: - It is used to create an empty table in the database.
Syntax: -
create table <table Name> (
<column 1> <data type> [not null] [unique] [<column constraint>],
. . . . . . . . .
<column n> <data type> [not null] [unique] [<column constraint>],
[<table constraint(s)>]
);
Examples: -
Creation of Teacher Table: -
create table Teacher (
TeacherID Number(10) ,
TeacherName Varchar2(30),
Qualification Varchar2(30),
Subject Varchar2(30),
ContactNumber Number(10) );
In the above example a table will be created with the name Teacher and TeacherID, TeacherName, Qualification, Subject and ContactNumber fields. This way we create all the tables discussed in the previous section.
