Featured Blog Posts – March 2011 Archive (1)

How to add IDENTITY column to existing table

Every DB2 admin discovers sooner or later that DB2 can not add identity column to existing table easily. Following statements fails due to syntax error: alter table public.clicks add column id integer generated always as identity


But i have good news for everyone. It can be still done, but it requires more steps.


1. Add not null integer column

You need to provide default value for it otherwise db2 will refuse it to make not…


Added by Radim Kolar on March 31, 2011 at 3:00pm — 2 Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service