PostgreSQL-Learning/alter.sql at main · Hazrat-Ali9/PostgreSQL-Learning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
-- Active: 1699467625194@@127.0.0.1@5432@ph@public


SELECT * from person4;

ALTER TABLE person2
    ADD COLUMN email VARCHAR(25)  DEFAULT 'default@mail.com' NOT NULL;

ALTER TABLE person2
    DROP COLUMN email;

ALTER TABLE person2
    RENAME COLUMN age to user_age;

ALTER TABLE person2
    ALTER COLUMN user_name TYPE VARCHAR(50);

ALTER TABLE person2
    ALTER COLUMN user_age set UNIQUE;

ALTER TABLE person2
    ALTER COLUMN user_age drop NOT null;


ALTER TABLE person2
    ADD constraint unique_person2_user_age UNIQUE(user_age);


ALTER TABLE person2
    DROP constraint unique_person2_user_age;


TRUNCATE TABLE person2;
DROP TABLE person2;


-- INSERT into person4 VALUES(10,'mizan', 45);