Saturday 4 June 2022

How To Drop Table In PostgreSQL Using SQL Shell psql and pgAdmin || Post...


Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.




CREATE TABLE IF NOT EXISTS public.employees
(
    empid bigint NOT NULL,
    salary real NOT NULL DEFAULT 100,
    name character varying(50) COLLATE pg_catalog."default" NOT NULL,
    deptno bigint DEFAULT 1,
    gender character varying(15) COLLATE pg_catalog."default" DEFAULT 'Female'::character varying,
    CONSTRAINT emp_pk PRIMARY KEY (empid)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.employees
    OWNER to postgres;

COMMENT ON TABLE public.employees
    IS 'This table will contain data for employees';
How To Drop Table In PostgreSQL Using SQL Shell psql and pgAdmin
Drop Table In PostgreSQL
How To Drop Table In PostgreSQL
PostgreSQL Tutorials
Drop Table In PostgreSQL Using SQL Shell psql
Drop Table In PostgreSQL Using pgAdmin
Table In PostgreSQL
SQL Shell psql
SQL
Shell
psql
pgAdmin

No comments:

Post a Comment