Tuesday, 8 December 2015

Netezza Common SQL commands

Nzsql commands 
ALTER DATABASE
To change the default 8-bit character set in the emp database, enter:
system(admin)=> ALTER DATABASE emp set default character set
latin9;
To rename the emp database, enter:
system(admin)=> ALTER DATABASE emp RENAME TO employees;
To change the owner of the emp database, enter:
system(admin)=> ALTER DATABASE emp OWNER TO admin3;