Member Avatar for user74

hello,

I have a table with int Primary key. Is there a way to set identity property on this field w/o dropping/recreating the table?

Thank you.

  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by rado
Member Avatar for rado

i thing that is

SET IDENTITY ON
insert INTO tb (id,.....) values(1,...)
SET IDENTITY OFF

, then you can set ident same as previous data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.