Maybe an easy question but... [message #367700] |
Fri, 19 November 1999 12:03 |
DFree
Messages: 1 Registered: November 1999
|
Junior Member |
|
|
I think this may be an easy question...
I need to create (using SQL at runtime from a vb app) an EXACT copy of a table, preserving primary keys, default values, indexes etc... I dont need the data mind you, just the EXACT table structure. a create table querry prserved the column name, length type, but I lost my keys, my indexes, and my default values. To clarify, my problem is not the execution of the SQL code from VB, but the actual SQL syntax for acomplishing the task. I would GREATLY appreciate any help you have to offer.
|
|
|
|