Implementing system generated keys

Database

Implementing system generated keys

Hi..

Could some one tell me the positive impact of implementing system generated keys via use of identity columns?

1 REPLY
Teradata Employee

Re: Implementing system generated keys

Well, for one .... youo dont need to generate it yourself. But it is better to generate it within your process .... SQL or though ETL tool. It gives you more control on data and can change/fix values in case of an issue.

With Identity column, you will need to be very careful migrating the data, and or fixing  issues as once the value is used, you cant re-use the same value and once the value is changed in the key-table, it will be requiring change in all child tables as well.