Creating Tables
Create table name(the_name varchar(50) primary key);
Insert into name values( 'Marge');
Insert into name values( 'Homer');
Insert into name values( 'Bart');
Insert into name values( 'Lisa');
Insert into name values( 'Maggie');
Insert into name values( 'Simpson');
Insert into name values( 'Burns');
Insert into name values( 'Monte');
Insert into name values( 'Krusty');
Insert into name values( 'Karl');
Select * from name;
drop table person;
Create table person (
person_id int primary key
);
Insert into person values(1);
Insert into person values(2);
Insert into person values(3);
Select * from person;
Create table person(
person_id int primary key,
last_name varchar(50),
first_name varchar(50)
);
Create table person(
person_id int primary key,
last_name varchar(50) references name,
first_name varchar(50) references name
);
Create table person (
person_id int generated always as identity primary key,
first_name varchar(50),
last_name varchar(50),
phone_number varchar(15)
);
Insert into person (first_name, last_name, phone_number) values( 'Marge', 'Simpson', '212-555-7585');
Insert into person (first_name, last_name, phone_number) values( 'Homer', 'Simpson', '212-555-7542');
Insert into person (first_name, last_name, phone_number) values( 'Lisa', 'Simpson', NULL);
Insert into person (first_name, last_name) values( 'Maggie', 'Simpson');
Select * from person;