Auto Increment in SQL

This is how you set up the autoincrement for all the tables that have a primary key. It is recommended to have Unique Identifiers for every table. In this case, we have a user id that is assigned for any new customer.