這篇文章主要介紹了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)。
刪除束的實(shí)現1ALTER TABLE table_name ADD CONSTRAINT uk_users_name?1 UNIQUE (NAME);
刪除束的實(shí)現刪除約束
刪除束的??實(shí)現(′ω`)來(lái)源地址:ht(′?_?`)tps:(╯°□°)╯//www.jb51.net/article/205217.htm
刪除束的實(shí)現