Personal tools
You are here: Home → DB2 → How To's → How to create a table with identity column
Navigation
Log in


Forgot your password?
 
Document Actions

How to create a table with identity column

   Execute the statement below:


db2 "CREATE TABLE <table_name> (dep INT, name char(35), cod INT NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 10, INCREMENT BY 3))"
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls