Create index syntax

[SSuhaib]

Hi,

I am connecting a Progress 9.1e database through Sql explorer. I created a table using SQl but unable to create an index. What is the exact syntax to create index on a table using SQL-92.

Thanks in advance.

 

[tamhas]

99.999% of the time, you do not want to create tables or indexes using SQL. Create them using the data dictionary.

 

[SSuhaib]

Thanks Tamhas. But this client uses JDBC to login and want to create tables & indexes and does not want to use Progress tools.
Any ideas, if any one has ever created indexes using JDBC client on Progress 9.1e.

TIA

 

[tamhas]

They are using a Progress database and NO ABL?

Creating schema from SQL has many perils which do not exist if you create the schema using the data dictionary. It isn't as if one creates new schema every day.