var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: finding all the identity column in DB2
how can we get all the existing identity and sequences in a database in DB2. we can use 2 different queries to find each one. Please help.
SELECT TABNAME, COLNAME FROM SYSCAT.COLUMNS WHERE IDENTITY = 'Y'
The above query gives all the table name and column name which has column as identity..
Any way thanks for ur consideration..
yes it does. Your other query gets the sequences I take it from your original mail. You want to run one query that gets them both at once and as I said try UNION
select cols from table1 where ....
select cols from table2 where...
Just ensure the columns match up with data type between the two queries.