Re: Query to find indexes for a specific table
Jerry Gitomer wrote:
>
> Is there a query I can set up that will permit our computer
> operators to determine if an index exits on a table?
> I know that I can go into DBACCESS and see the indexes for
> a table, but I don't plan to on premises when the third shift
> operator starts up the joins at 3:00 AM :-) So our operations
> manager asked me to come up with an EASY way for an operator
> to find out if the indexes exist.
You can write a SQL script for dbaccess:
dbaccess dbname - <<!
info indexes for table1;
info indexes for table2;
!
Which may be what you want.
Hope that helps,
Douglas Wilson