Monday, 26 May 2014

How to create a table with identity column

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))"

No comments:

Post a Comment