Question

Write an SQL command that creates a SHOP table. The table should have a shop_id, a shop_name, a shop_location

Answer 1

IN THE PROCESS OF CREATING THE SQL TABLE WE HAVE TO DEFINE THE FOLLOWING :

1. Name of the Table

2.Define Number of tables

3.Data types of the Column

In our project we need to create a shop table

We have 3 Column tables

1.Shop id :- Data type : Integer . its a Primary Key

2.Name :- variable Character Filed . It is set to hold 30 Characters

3.Shop Address : variable Character Filed . It is set to hold 60 Characters

Now we can implement the Syntax :

Use test ;

CREATE TABLE SHOP

(

SHOPID int primary key ,

SHOPNAME varchar(30) ,

SHOPLOCATION varchar(90)

);

DESC shop ;