Member Avatar for Parth_3

hiii frnds
i am work in vb.net windows application now in sql empid field is Unique (primary key) that how can i impliment and handle Empid manually

  • 2 Contributors
  • 1 Reply
  • 249 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

What do you mean by handle it manually? One of the benefits of an auto-incrementing ID column is that you don't have to look after it yourself, you can let it automatically adjust for new entries.
But if you want to make that column not a primary key you can run this command in SQL:
ALTER TABLE <table name> MODIFY COLUMN empid int;

And it'll just become a plain int column with no unique constraints on it.
But, there is also a good chance I've failed to understand what you really mean.

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.