Skip to content

Instantly share code, notes, and snippets.

@tuxcuiabano

tuxcuiabano/tableaddress.sql

Created September 17, 2019 12:09
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/03c56ae066ed15ec39fc8863bfe8804c to your computer and use it in GitHub Desktop.
Save tuxcuiabano/03c56ae066ed15ec39fc8863bfe8804c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tableaddress.sql
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 ('Joao','Lima','joao@tuxcuiabano.com','555-5555'),
('Maria','Rita','maria@tuxcuiabano.com','555-1234');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment