Is it necessary to place the PRIMARY KEY at the end of the table creation statement?

It is not necessary to place the PRIMARY KEY at the end of the table creation statement. The PRIMARY KEY can be specified anywhere within the table creation statement. However, it is a common practice to define the PRIMARY KEY at the end for readability and consistency in the code. 

CREATE TABLE table_name (
    column1 INT,
    column2 VARCHAR(50),
    PRIMARY KEY (column1)
);

Keywords

PRIMARY KEY table creation statement PHP database

Related Questions