Skip to content

Instantly share code, notes, and snippets.

@tuxcuiabano

tuxcuiabano/AddressBook.sql

Created December 2, 2020 21:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tuxcuiabano/81a9a29d6192e38b7b60264a18b689d2 to your computer and use it in GitHub Desktop.
Save tuxcuiabano/81a9a29d6192e38b7b60264a18b689d2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AddressBook.sql
DROP TABLE Addresses;
CREATE TABLE Addresses
(
AddressID INT NOT NULL GENERATED ALWAYS AS IDENTITY,
FirstName VARCHAR (15) NOT NULL,
LastName VARCHAR (30) NOT NULL,
Email VARCHAR (30) NOT NULL,
PhoneNumber VARCHAR (15) NOT NULL
);
INSERT INTO Addresses (FirstName,LastName,Email,PhoneNumber)
VALUES ('Mike','Green','demo1@deitel.com','555-5555'),
('Mary','Brown','demo2@deitel.com','555-1234');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment