Etiket Arşivi: primary key

alter table tblname add id integer; create sequence tblname_seq; update tblname set id = tblname_seq.nextval; drop sequence tblname_seq; alter table tblname modify (id serial not null); ALTER TABLE tblname ADD CONSTRAINT PRIMARY KEY (id);  

SELECT a.tabname, b.constrname, d.colname FROM systables a, sysconstraints b, sysindexes c, syscolumns d WHERE a.tabname = :table_name AND b.tabid = a.tabid AND c.idxname = b.idxname AND d.tabid = a.tabid AND ( d.colno = c.part1 or d.colno = c.part2 or d.colno = c.part3 or d.colno = c.part4 or d.colno = c.part5 …