postgreSQL

psql -h localhost -d postgres CREATE TABLE subjects(id int GENERATED ALWAYS AS IDENTITY PRIMARY KEY,name varchar(20) NOT NULL); Alter table ALTER TABLE subjectsADD COLUMN credits varchar(10) NOT NULL; ALTER TABLE subjectsADD COLUMN credits INT; Drop ...