“Be not afraid of going slowly, Be afraid of standing still.”
Creating a Table with a Unique Primary Index
This is a basic TABLE CREATE STATEMENT. You have Columns and the data types in them. As you see, the Primary Index is defined for a Table at TABLE CREATE time.
Creating a Table with a Non-Unique Primary Index
A Non-Unique Primary Index (NUPI) is on the above table. Notice how you only need to put ‘Primary Index’.
Creating a Table and forgetting to put in a Primary Index Clause ...