\\ALTER TABLE to ADD PRIMARY KEY constraintĪDD CONSTRAINT MyPrimaryKey PRIMARY KEY (column1, column2. \\ALTER TABLE to ADD CHECK CONSTRAINT to a tableĪDD CONSTRAINT MyUniqueConstraint CHECK (CONDITION) \\ALTER TABLE to ADD UNIQUE CONSTRAINT to a tableĪDD CONSTRAINT MyUniqueConstraint UNIQUE(column1, column2.) \\ALTER TABLE to add a NOT NULL constraint to a columnĪLTER TABLE table_name MODIFY column_name datatype NOT NULL \\ALTER TABLE to change the DATA TYPE of a columnĪLTER TABLE table_name ALTER COLUMN column_name TYPE datatype To create a PostgreSQL table column with auto increment, set type SERIAL. \\ALTER TABLE to DROP COLUMN in an existing tableĪLTER TABLE table_name DROP COLUMN column_name
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |