SELECT tabname FROM database_name:systables t1 WHERE t1.tabid >= 100 AND NOT EXISTS (SELECT * FROM database_name:syscolumns c WHERE c.tabid = t1.tabid and c.colname = 'adddate' ) order by 1;
SELECT tabname FROM database_name:systables t1 WHERE t1.tabid >= 100 AND NOT EXISTS (SELECT * FROM database_name:syscolumns c WHERE c.tabid = t1.tabid and c.colname = 'adddate' ) order by 1;
Etiketlerinformix
alter table tblname add id integer; create sequence tblname_seq; update tblname set id = tblname_seq.nextval; …