I want to add AUTO_INCREMENT column in my look up table.
And i want to use that auto increment column for join purpose.
Please can i know Pros and crons of using AUTO_INCREMENT column .
I want to use as primary key .
Teradata "IDENTITY" columns are not the same as AUTO_INCREMENT columns in SQL Server.
The DDL manuals (especially the "Detailed Topics") explain how IDENTITY columns work.