Its not possible to do that since we have already lot of records now and we need to follow the same standard.

Pls help me out in this .

Thanks

Thanks for the solution...

But one more itch is there...

I need to get the maximum count of temp_ID from temp1 table and insert the next temp_id value +1.

Can you pls tell...

Temp1 depends on Temp table.

So if there is any duplicate records it will give me foreign key constraints error.

Thanks

Can you pls explain me how it works in case its primary key foreign key relationship.

Thanks for the reply.

My intention is multirow insert .

whenever new row is inserted in Temp table,In temp1 also this should be inserted.

Pls let me know the better way.

Thanks