Create Users table program in SQL

Create Users table

Refer to the below schema and create the table USERS.

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 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

Scroll to Top