Re: Finding missing ID

2002-10-12 Thread Peter Brawley
Chuck, I have database that has grown in size, I want to see what ID files have been deleted. Is there a way or do I have to print out the list and find them myself? Assuming by files you mean rows, and assuming a table named t1, a column in it named id, and you having done something like

Finding missing ID

2002-10-12 Thread Chuck \PUP\ Payne
Hi, I have database that has grown in size, I want to see what ID files have been deleted. Is there a way or do I have to print out the list and find them myself? Is there a sql or query statement that will let me find them. Chuck Payne