Q. How do I copy a table structure
Uhh... with DAO, RDO, ADO, or ODBC?
... will you settle for an SQL statement?
Quote:
>I'm having a problem which I'm sure is quite simple; I just can't figure it
>out. I want to copy a structure of a table within a database and give it a
>different name. I don't want to copy the records, just the table structure.
> Can anyone supply a sniplet of code to demonstrate how this is done. I've
>already spent way too many hours trying to figure it out.
>BTW..I know in Dbase or Clipper, I would just use a "COPY STRUCTURE"
>command. VB just don't understand that :).
>Any help would be appreciated.
>Thanks
