@sql-extra/alter-domain v0.1.1

Change the definition of a domain (ALTER DOMAIN).

const alterDomain = require('@sql-extra/alter-domain');
// alterDomain.setDefault(<name>, [expression])
// alterDomain.dropDefault(<name>)
// alterDomain.setNotNull(<name>)
// alterDomain.dropNotNull(<name>)
// alterDomain.addConstraint(<name>, <constraint_expression>, [not_valid=false])
// alterDomain.dropConstraint(<name>, <constraint_name>, [cascade=default], [if_exists=false])
// alterDomain.renameConstraint(<name>, <constraint_name>, <new_constraint_name>)
// alterDomain.validateConstraint(<name>, <constraint_name>)
// alterDomain.ownerTo(<name>, <new_owner>)
// alterDomain.renameTo(<name>, <new_name>)
// alterDomain.setSchema(<name>, <new_schema>)
// -> SQL query


alterDomain.setNotNull('zipcode');
// ALTER DOMAIN "zipcode" SET NOT NULL;

alterDomain.dropNotNull('zipcode');
// ALTER DOMAIN "zipcode" DROP NOT NULL;

alterDomain.addConstraint('zipcode', '"zipchk" CHECK (char_length(VALUE) = 5)');
// ALTER DOMAIN "zipcode" ADD CONSTRAINT "zipchk" CHECK (char_length(VALUE) = 5);

alterDomain.dropConstraint('zipcode', 'zipchk');
// ALTER DOMAIN "zipcode" DROP CONSTRAINT "zipchk";

alterDomain.renameConstraint('zipcode', 'zipchk', 'zip_check');
// ALTER DOMAIN "zipcode" RENAME CONSTRAINT "zipchk" TO "zip_check";

alterDomain.setSchema('zipcode', 'customers');
// ALTER DOMAIN "zipcode" SET SCHEMA "customers";