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

Code:

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)

);

• Tweet
• Share
• Share
• Share
• Share

Related Post