ALTER TABLE orders RENAME COLUMN customer_email TO email; ALTER TABLE orders ALTER COLUMN email SET NOT NULL; SELECT column_name FROM information_schema.columns WHERE table_name = 'orders'; SELECT constraint_name FROM information_schema.table_constraints WHERE table_name = 'orders';