how to create table using sql

step1:open sql command prompt
step2:type the following code

sql>create table tab1
               (id int not null,
                name varchar(10),
                email_id varchar(20),
                constraint pk primary key(name),
                constraint uk unique(email_id)); 

step3: to view the table format type

    sql> desc tab1;

step4: inserting values into table

    sql>insert into tab1(id,name,email_id)values (5,'ashok','asssss@gmail.com');
    sql>insert into tab1(id,name,email_id)values (6,'amzu','gdddjsss@gmail.com');