Question

Write the SQL statement to create a table, Customer with the following specifications:

Table: Customer
Column Name	Data Type	Key
CID	Int	Primary Key
FName	Varchar (20)
LName	Varchar (20)
Age	Int

Answer 1

CREATE TABLE CUSTOMER
(
CID INT PRIMARY KEY,
FNAME VARCHAR (20),
LNAME VARCHAR (20),
AGE INT
);