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

How to know identity column in DB2?

View previous topic View next topic Go down

How to know identity column in DB2?

Post by srini on 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

View user profile

Back to top Go down

Re: How to know identity column in DB2?

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

This query works

srini

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

View user profile

Back to top Go down

Re: How to know identity column in DB2?

Post by srini on 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

View user profile

Back to top Go down

Re: How to know identity column in DB2?

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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