CREATE TABLE TEST.TEST (
	S_BIGINT Integer NOT NULL,
	S_DECIMAL Numeric,
	S_REAL Float,
	S_DOUBLE Float,
	S_INTEGER Integer,
	S_SMALLINT Integer
);

ALTER TABLE "TEST"."TEST" ADD CONSTRAINT UQ_1 UNIQUE(S_BIGINT)

SELECT column_name as column_name, ORDINAL_POSITION as key_seq, CONSTRAINT_NAME FROM PRIMARY_KEYS WHERE TABLE_SCHEMA='TEST' AND table_name = 'TEST' ORDER BY CONSTRAINT_NAME, ORDINAL_POSITION

SELECT column_name as column_name, CONSTRAINT_NAME, table_name FROM CONSTRAINT_COLUMNS WHERE TABLE_SCHEMA='schema_name' AND table_name = 'table_name' AND CONSTRAINT_TYPE IN ('u', 'p')