SriniForum
Hello Friend,
Welcome to Fully Optimized Discussion Forum.
Leading Forum in India

Join the forum, it's quick and easy

SriniForum
Hello Friend,
Welcome to Fully Optimized Discussion Forum.
Leading Forum in India
SriniForum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SriniForum

IT Geeks Adda


How to know identity column in DB2?

SriniForum  :: Legacy Systems :: Mainframe - Discussion Forum :: DB2 -Discussion Forum

Go down

How to know identity column in DB2? Empty How to know identity column in DB2?

Post by srini Sat Nov 01, 2014 8:03 am

The answer is:

SELECT TABNAME,COLNAME FROM SYSIBM.SYSCOLUMNS

WHERE IDENTITY = 'Y'

srini

Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16

Back to top Go down

How to know identity column in DB2? Empty Re: How to know identity column in DB2?

Post by srini Sat Nov 01, 2014 8:04 am

This query works

srini

Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16

Back to top Go down

How to know identity column in DB2? Empty Re: How to know identity column in DB2?

Post by srini Wed Nov 05, 2014 6:35 am

The correct query is

SELECT TABNAME,COLNAME FROM SYSIBM.SYSCOLUMNS

WHERE DEFAULT = 'I'

srini

Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16

Back to top Go down

How to know identity column in DB2? Empty Re: How to know identity column in DB2?

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

SriniForum  :: Legacy Systems :: Mainframe - Discussion Forum :: DB2 -Discussion Forum

 
Permissions in this forum:
You cannot reply to topics in this forum