Adding Index in Create Table Statement

Question

Is there anyway way you can do this? I know there are separate statements to explicitly state this but is there a way you can specify an index in the create table statement?

Aditya Naidu · Accepted Answer · 2012-06-03 13:01:21Z

1

CREATE TABLE lookup
(id INT, INDEX USING BTREE (id))

edited Jun 3, 2012 at 13:01

answered Jun 3, 2012 at 3:43

Aditya Naidu

1,3709 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Adding Index in Create Table Statement

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related