Creating index

[Dave_D]

With SQL, I'm able to create a new table. In the same SQL, can indexes be created? If yes, what is the proper syntax? I've tried
[My Field1] text (255) CONSTRAINT[My Field1x], [My Field2] text (255) CONSTRAINT[My Field2x].

If no, I was able to create my index with SQL Create Index [My Filed1] on TableName [My Field1x] but was only able to create a single index. Can multiple indexes be created within a single SQL statement or does each index need it's own SQL?

[ranman256]

there's really no need to do it in sql when you can just click design , put in the fields then save.

[Gicu]

Yes you can create indexes when creating the table, have a look at this link:
https://www.oreilly.com/library/view...7/ch01s15.html
Cheers,