Drop/Create tables

Objective:

  • DROP table if exists
  • Create Table using role manas237
 Role: manas237

-- DROP ROLE manas237;

CREATE ROLE manas237 LOGIN
ENCRYPTED PASSWORD 'md5b14afbf9d130ffaf51501a1cd619ec3e'
NOSUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
 
You view the user's profile :

 
Let us Update the table
Open a new window

Code Used :

DROP TABLE IF EXISTS birthdays;
CREATE TABLE birthdays (
fname varchar(80),
lname varchar(80),
dob date
);

INSERT INTO birthdays (fname, lname, dob) VALUES ('John ', 'Smith', '1999-01-31');
INSERT INTO birthdays (fname, lname, dob) VALUES ('John', 'Sedlachek', '1997-03-04');
INSERT INTO birthdays (fname, lname, dob) VALUES ('Adam', 'Smeth', '1997-12-02');
INSERT INTO birthdays (fname, lname, dob) VALUES ('Nancy', 'Cooper', '200-11-28');
now after updating the script

Using PHP query Tool : ( logged in as a super user )