>What is syntax to create an empty copy of an existing table.
>
>In Foxpro I just use "copy stru to"
>
>What do I do in SQL?????
>
>I am goingto use SQLEXEC() in Foxpro to actually run it
If you just want to create a new table based on another existing one, you can use this:
SELECT TOP 0 *
INTO NewTableName
FROM ExistingTable
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com