Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alter Column and add identity to integer data type

Status
Not open for further replies.
gibs01

gibs01

IS-IT--Management
Jul 22, 2003
1
IN
Dear All
Create table books (bookid int, name varchar(20))

How do i alter a column bookid and change it to generated Identity column ? I would like the exact syntax with an example .
Regards
Gibu
 
Status
Not open for further replies.

Similar threads

C
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
262
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
298
tekpr00
tekpr00
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
115
usr1234
usr1234
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
302
walter.weinmann
walter.weinmann
Pauljohn44
  • Locked
  • Question
Pivot data with two key fields
Replies
0
Views
156
Pauljohn44
Pauljohn44

Part and Inventory Search

Sponsor

Back
Top