PostgreSQL 刪除check約束的實(shí)現

這篇文章主要介紹了PostgreSQL 刪除check約束的刪除束的實(shí)??現實(shí)現，具有很好的刪除束的實(shí)現參考價(jià)值，希望對大家有所幫助。刪除束的??實(shí)現一起跟隨小編過(guò)來(lái)看看吧。刪除束的實(shí)現

刪除c??heck約束：

1.\d table_name 查找約束名稱(chēng)

\d dm_alarms_fct_20170613 "dm_alarms_fct_20170613_dm_t(/ω＼)ransct_date_key_check"

補充：PostgreSQL查詢(xún)約??束和創(chuàng )建刪除約束

查詢(xún)約束constrain(′?｀*)t

SELECT
tc.constraint_name(′?_?`),刪除(/ω＼)束的實(shí)現 tc.table_name, kcu.column_name,
ccu.table_name AS(O_O) foreign_ta??ble_name,
ccu.column_name AS foreign_column_??name,
tc.is_deferrable,tc.initially_deferred
FROM
information_schema.table_cons(′Д` )traints AS tc
JOIN information_schema.key_column_usage AS kcu ON tc.constrai(′_｀)nt_name = kcu.constrヽ(′?｀)ノaint_name
JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.co??nstraint_name
WHERE constraint_type = 'UNIQUE' AND tc.table_(′-ι_-｀)name = 'table_name';

c(◎_◎;)onst??raint_type有四種：

UNIQUE、PRIMARY KEY、刪除束的實(shí)現CHECK、刪除束的實(shí)現FOREIGN KEY,刪除束的實(shí)現 通過(guò)修改上邊sql語(yǔ)句的table_name和constraint_type來(lái)進(jìn)行相??應的查詢(xún)。

1ALTER TABLE table_name ADD CONSTRAINT uk_users_name?1 UNIQUE (NAME);

刪除約束

來(lái)源地址：ht(′?_?`)tps:(╯°□°)╯//www.jb51.net/article/205217.htm