How to get Table Parameters to copy table

[Joe]

Hey all,

I'm trying to do the following in ASP :

- Determine the parameters(field names and data types) of a
table .
- Create a new table with these same parameters.
- Insert all data from first table into copied table.

Any suggestions as to what a reliable solution might be for this would
be appreciated.

Thanks,

Joe

[Bob Barrows]

Joe wrote:

> Hey all,
>
> I'm trying to do the following in ASP :
>
> - Determine the parameters(field names and data types) of a
> table .
> - Create a new table with these same parameters.
> - Insert all data from first table into copied table.
>
> Any suggestions as to what a reliable solution might be for this would
> be appreciated.
>
> Thanks,
>
> Joe

Why didn't you think your database type and version would be relevant? There
is no way we can answer this question without that information.


Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[TomB]

If you are using SQL Server, take a look at DTS(Data Transformation
Services).
If you are using Access, I would use ADOX (but there may be a better way)


"Joe" <jbassil@cs.dal.ca> wrote in message
news:a4ac3447.0311270613.2e76d2ef@posting.google.c om...

> Hey all,
>
> I'm trying to do the following in ASP :
>
> - Determine the parameters(field names and data types) of a
> table .
> - Create a new table with these same parameters.
> - Insert all data from first table into copied table.
>
> Any suggestions as to what a reliable solution might be for this would
> be appreciated.
>
> Thanks,
>
> Joe

[Joe Bassil]

I'm using SQL Server 7, and would like to essentially mimmick the
functionality of the 'Generate SQL Script' command. I've considered
using DTS to get me going, but would appreciate your suggestions...

thanks,
Joe



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Foo Man Chew]

If you don't care about indexes and constraints, you can say:

SELECT * INTO newTable FROM oldTable

This will create a table with the same structure, and populate it with a
copy of the existing data.


"Joe Bassil" <jbassil@cs.dal.ca> wrote in message
news:eLa6TXPtDHA.2456@TK2MSFTNGP12.phx.gbl...

> I'm using SQL Server 7, and would like to essentially mimmick the
> functionality of the 'Generate SQL Script' command. I've considered
> using DTS to get me going, but would appreciate your suggestions...
>
> thanks,
> Joe
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Aaron Bertrand [MVP]]

> If you don't care about indexes and constraints, you can say:

>
> SELECT * INTO newTable FROM oldTable

Just as another disclaimer, this can also cause problems with IDENTITY
columns, computed columns, primary keys, triggers, defaults (yes, primary
keys and defaults are constraints, but they deserve individual mention as
well).

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]