Monday, 5 September 2022

Postgresql - Add/Remove primary key

 ALTER TABLE MY_TABLE_NAME ADD PRIMARY KEY (COLUMN_1, COLUMN_2);

ALTER TABLE MY_TABLE_NAME DROP CONSTRAINT TEST1_PKEY;

No comments:

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...