(with VFP9SP2 app)

I'm developing code where I'm creating client-specific tables based on original model tables. I'm using SHOW CREATE TABLE `<<dbc>>`.`<<table>>` to get the CREATE TABLE syntax. However, while that will make a duplicate table (after I create a new name of course), it does not create the indexes that go with it.

Does anyone know which meta-table the index expressions are kept? I was so excited that it was so easy to get the CREATE TABLE syntax with one command, but without the indexes, that kinda defeats what I was trying to do.

Thanks,
--Mike


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to