这篇文章主要介绍了PostgreSQL 删除check约束的实现，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧。

 

删除check约束：

 

1.\d table_name 查找约束名称

 

\d dm_alarms_fct_20170613 "dm_alarms_fct_20170613_dm_transct_date_key_check"

 

2.alter table .. drop constraint ..

 

1ALTER TABLE "dm_alarms_fct_20170613" Drop constraint "dm_alarms_fct_20170613_dm_transct_date_key_check";

 

补充：PostgreSQL查询约束和创建删除约束

 

查询约束constraint

 

SELECT

   tc.constraint_name, tc.table_name, kcu.column_name,

   ccu.table_name AS foreign_table_name,

   ccu.column_name AS foreign_column_name,

   tc.is_deferrable,tc.initially_deferred

 FROM

   information_schema.table_constraints AS tc

   JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name

   JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name

 WHERE constraint_type = 'UNIQUE' AND tc.table_name = 'table_name';