Hey list,
I need a query that checks if a certain table column has type auto-increment If not set it to auto increment, else do nothing. Let's say I have the table objects (object_id, object_name) in which object_id is the primary field. Now check to see if object_id is auto_increment and if not set it auto_increment Can anyone help me on this? I've been looking into the manual but I can't get it right: Alter table objects change object_id type auto_increment Thx in advance, Reinhart
