Create index on create table

Question

Can I create an index on a CREATE TABLE statement?
I.e. can I define indexes for a table when I create the table? I mean create the index on the create stamement sql command

jpesout · Accepted Answer · 2013-10-16 09:03:37Z

33

Yes, it can be defined in the CREATE TABLE, the convention is to put these definitions at the end of the list.

CREATE TABLE `example`
(
    `id` INTEGER  NOT NULL AUTO_INCREMENT,
    `index_col` VARCHAR(20),
    PRIMARY KEY (`id`),
    INDEX `index_name` (`index_col`)
)

answered Oct 16, 2013 at 9:03

jpesout

7385 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jim Over a year ago

The only relevant answer. +1

Moritz Over a year ago

As a caveat, in PostgreSQL it is not possible to add an index in the CREATE TABLE command. This requires a separate CREATE INDEX command.

Collectives™ on Stack Overflow

Create index on create table

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related