Home » RDBMS Server » Networking and Gateways » Maybe an easy question but...
Maybe an easy question but... [message #367700] Fri, 19 November 1999 12:03 Go to next message
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.
Re: Maybe an easy question but... [message #367704 is a reply to message #367700] Mon, 22 November 1999 11:21 Go to previous message
Rajesh Matkar
Messages: 20
Registered: September 1999
Junior Member
Hi, Take export of table and Import with different name or take export and rename existing table and import it.
Try it.

Rajesh Matkar
Previous Topic: Can I import a local database to a remote database via TCP/IP by SQL*NET
Next Topic: Problem in Login to database
Goto Forum:
  


Current Time: Sat Apr 20 02:52:03 CDT 2024