Create Users table program in SQL

Create Users table

Refer to the below schema and create the table USERS.

Column Name

Datatype

Size

Constraint

Constraint name

User_id

Number

11

Primary key

PK_USERS

Name

Varchar2

20

   

Address

Varchar2

100

   

Phno

Number

11

   

Emailid

Varchar2

30

   

Create Users table program in SQL

create table USERS(
	User_id number(11),
  	Name varchar2(20),
  	Address varchar2(20),
  	Phno number(11),
  	Emailid varchar2(30),
  	constraint PK_USERS primary key(User_id)
);

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program

Leave a Comment