PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

ALTER TYPE

劉䓄

ALTER TYPE  -- 媞櫹婔婻䌂傋䔇垔幬

臺濘

ALTER TYPE name OWNER TO new_owner 
ALTER TYPE name SET SCHEMA new_schema

柟誄

ALTER TYPE 櫹埻婔婻䯄庻䌂傋䔇垔幬㔗䕞嬉脘䫘䔇嫇婔䔇媘脘儌滇媞櫹婔婻䌂傋䔇欔橬蔙启昇嚟㔗

襕嘪䫘 ALTER TYPE 嘹媙釂拖橬臖䌂傋㔗襕媞櫹婔婻䌂傋䔇昇嚟嘹誻媙釂婘桄昇嚟婪拖橬 CREATE 溄鍊㔗襕媞櫹欔橬蔙嘹誻媙釂滇桄䔇欔橬蓐謾䔇䕘毖潡閘毖潊叻幽婫臖潊叻媙釂婘溴䌂傋䔇昇嚟婪橬 CREATE 溄鍊㔗認底鍊彽嚺彽庖媞櫹臖欔橬蔙婉嚔啔傂嘘锔誺役鍴启麉傺䌂傋婉脘啔䔇庋愙㔗婉誺轙亓䫘潙埇傖傖傂嘘桹嚟媞櫹傂懟䌂傋䔇欔橬溄㔗

埗昄

name

婔婻驔襕媞櫹䔇䯄橬䔇䌂傋䔇劉庖(埇傖橬昇嚟媞閄)

new_owner

桄欔橬蔙䔇䫘潙劉

new_schema

臖䌂傋䔇桄昇嚟

冋床

襕櫹埻婔婻䫘潙垔幬䌂傋 email 䔇欔橬蔙婺 joe

ALTER TYPE email OWNER TO joe;

檪䫘潙垔幬䌂傋 email 䔇昇嚟櫹埻婺 customers

ALTER TYPE email SET SCHEMA customers;

噚垹攓

SQL 湺庖麯澇橬 ALTER TYPE 臺埖㔗

劯锔饡釕嬉誕
ALTER TRIGGER婪婔亓ALTER USER