Page 1 of 1

id INT PRIMARY KEY question

Posted: Wed Jun 01, 2005 11:01 am
by jaymoore_299
Is there a way to delete a particular primary key in the middle of a table then re-sort them so that there are no gaps between numbers?

I'm not exactly sure when to use id INT. On what kind of data would one need such an index, and on what kind of data could one neglect its use?

Is it easier to delete rows (without making as many mistakes such as deleting the wrong row) with the use of this index?

Posted: Wed Jun 01, 2005 2:29 pm
by timvw
multiposting is not cool.