Mufi,
This depends on what your back-end data is. I'm pretty sure that SQL Server can NOT handle this type of situation, but I don't know about other back-ends. My question to you is *why* do you want to do this? Is this column a PK (Primary Key)? If so, you shouldn't attach any meaning to it, which is what you would be doing by trying to make the values sequential.
~~Bonnie
>hi , every body
>
>i want watch on identity column, i meant to say that if any column delete from table which has identity column, when new column add check identity column that any number is missing if then insert that missing number if not then continue with next number.
>
>E.g 1,2,3,4
>
>Now i delete 2 no column , When new column add it will be 2, if no column delete then next will be 5
>
>Thanks
>Mufi