Embedded Files
CREATE TABLE ..... creates a new table
SQL OnLine IDE - CREATE TABLE.mp4
Have a go at this exercise:
create table car_sales
(
make varchar(20) ,
model varchar(20) ,
purchase_price int ,
purchase_date date ,
sold_price int ,
sold_date date ,
carname varchar(40) ,
EmptyField varchar(20)
)
EXAM TIP: Past exams show that it is unlikely you will be asked to create a table in the exam, however you need to know how to do it before you learn all of the other statements that you will need in the exam.
Creating a table is the first step. You need to CREATE a table before you can SELECT from it!
The CREATE TABLE statement is not a part of the AQA Specification
Page updated
Google Sites
Report abuse