CREATE COMMAND IN SQL

CREATE COMMAND:
used to create  a basic table involves name of  the table and defining its columns and each column's data type.

SYNATX:

CREATE TABLE table_name(
   column1 datatype,
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
   PRIMARY KEY( one or more columns )
);

EXAMPLE:

create table student( rno number(10),
name  varchar2(25),
mark1 number(3),
mark2 number(3),
mark3 number(3),
result varchar2(10),
class varchar2(10));



No comments:

Post a Comment