Implementing system generated keys


Implementing system generated keys


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

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.