Database

Identify the Query :

CREATE TABLE table_name (

column1 datatype,

column2 datatype,

...);

Data Type of Contrator Name

• Date / Time

• Int

• Varchar

Data Type of Address

• Int

• Varchar

• Date / Time

Syntax Identification :

SELECT * FROM table_name

where condition;

Identify Syntax : SELECT * FROM table_name;

Data Type of Schedule

• Int

• Varchar

• Date / Time

• Auto Increment

Identify the Query :

drop table table_name

Syntax Identification :

Delete from table_name where condition;

Data Type of Price

• Date / Time

• Int

• Varchar

Data Type of DatePurchase

• Date / Time

• Varchar

• Int