ALTER TABLE users ALTER COLUMN age TYPE INTEGER; ALTER TABLE users ALTER COLUMN age TYPE INTEGER USING age::INTEGER; ALTER TABLE users RENAME COLUMN fullname TO full_name; ALTER TABLE users ALTER COLUMN email SET NOT NULL; ALTER TABLE orders ALTER COLUMN status SET DEFAULT 'new';