Create Users table in SQL

Question:

Create Users table

Refer the below schema and create the table USERS.

Column NameDatatypeSizeConstraintConstraint name
User_idNumber11Primary keyPK_USERS
NameVarchar220  
AddressVarchar2100  
PhnoNumber11  
EmailidVarchar230  
Quiz for Exam -  Create Users table

dd13.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)
);

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *

x