@sql-extra/alter-collation v0.1.5

Change the definition of a collation (ALTER COLLATION).

const alterCollation = require('@sql-extra/alter-collation');
// alterCollation.refreshVersion(<name>)
// alterCollation.renameTo(<name>, <new_name>)
// alterCollation.ownerTo(<name>, <new_owner>)
// alterCollation.setSchema(<name>, <new_schema>)
// -> SQL query


alterCollation.renameTo('de_DE', 'german');
// ALTER COLLATION "de_DE" RENAME TO "german";

alterCollation.ownerTo('en_US', 'amaravati');
// ALTER COLLATION "en_US" OWNER TO "amaravati";

alterCollation.setSchema('en_US', 'myschema');
// ALTER COLLATION "en_US" SET SCHEMA "myschema";

alterCollation.refreshVersion('en_US');
// ALTER COLLATION "en_US" REFRESH VERSION;