Extract indexes
Hello is there a way to extract only the indexes of a table ? non the whole schema. thanks in advance
Do you need the SQL or just the index structure? If the latter, you can
ask dbaccess. In commandline mode:
info indexes for <table>;
You can get the same from the Info menu choice in the dbaccess menus.
If you need the SQL and have my dbschema replacement utility, myschema, you
can pass two filenames on the commandline and myschema will place indexes,
constraints, triggers, and privileges to the second file. You can redirect
the privs with the -g option, so:
myschema -d mydatabase -t tablename -g /dev/null /dev/null index_file.sql
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Apr 3, 2013 at 6:55 PM, SMITH JOHN <daylight@webmails.com> wrote:
> Hello
>
> is there a way to extract only the indexes of a table ? non the whole
> schema.
>
> thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01160ddee3fff004d97db243