Disadvantage of using AUTO_INCREMENT COLUMN?

Database
Enthusiast

Disadvantage of using AUTO_INCREMENT COLUMN?

Hi , 

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 .

 

Thanks.

1 REPLY
Highlighted
Teradata Employee

Re: Disadvantage of using AUTO_INCREMENT COLUMN?

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.