CREATE TABLE Manufacturers (
Code int not null,
Name varchar(20) not null,
PRIMARY KEY (Code));

describe Manufacturers;

INSERT INTO Manufacturers VALUES (1, 'Sony');
INSERT INTO Manufacturers VALUES (2, 'Creative labs');
INSERT INTO Manufacturers VALUES (3, 'Hewlett-Packard');
INSERT INTO Manufacturers VALUES (4, 'Iomega');
INSERT INTO Manufacturers VALUES (5, 'Fujitsu');
INSERT INTO Manufacturers VALUES (6, 'Winchester');

SELECT * FROM Manufacturers;