Database Systems - Primary Keys - Creating Tables with a Primary Key in SQL

You can apply rules or constraints to your database table when you create it with CREATE TABLE, or later on with ALTER TABLE.

The PRIMARY KEY constraint specifies that the column has unique rows. Typically, a column such as ID is made a primary key. Also, so that you don’t have to worry about always providing an ID every time a new row is added, and to not worry about duplicating an ID, you can auto-increment it.

Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!