Identity columns

Results 1 to 3 of 3

Thread: Identity columns

  1. #1
    Barry Guest

    Default Identity columns

    hi,<BR> we have 271 tables each with a column that should be set to an identity but unfortunately are set to accepting nulls and not inserting an identity.<BR>These tables have loads of data in them including some rows that do have unique id&#039;s.<BR>Is there a way of adding the identity property to all the tables but retaining the existing data and id&#039;s<BR><BR>Thanks in advance

  2. #2
    Steve Cimino Guest

    Default RE: Identity columns

    Are you going to add the identity column to the unique ids? Or are you creating a new field with something like an autonumber?<BR><BR>Changing the current field value of NULL is pretty easy with a query. Post more on exactly what you&#039;re trying to do.

  3. #3
    Barry Guest

    Default RE: Identity columns

    There is already a column with UIDs in it but these are inserted manually and not autoincremented.<BR>We want to add the UID autoincrement to this existing column without destroying any of the existing values in the column.<BR>I can remove the NULL acceptance with the ALTER TABLE command but it complains if I use IDENTITY (1,1) along with it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts