alter domain sql code example
Example: alter domain sql
ALTER DOMAIN { ime | staro_ime TO novo_ime }{
[SET DEFAULT {literal | NULL | USER | ….}]
| [DROP DEFAULT]
| [ADD [CONSTRAINT] CHECK (<pogoji>)]
| [DROP CONSTRAINT]
|TYPE tip_domene };
---------------------------------------------------------------
Primer:
ALTER DOMAIN DTip_davka TO Domena_DDV;
ALTER DOMAIN Dspol SET DEFAULT 'M';