Thursday, March 22, 2012

Copying table structure using VS 2005

I is possible to copy the structure of an existing SQL 2000 table to make a new table with Visual Studio 2005?Definetely. Just generate the script either in Query Analyzer of using Enterprise Manager and execute it ont he SQL 2005 server.|||

The database is SQL 2000 and I was wondering if Visual Studio 2005 offered any native capability to copy table structure. It offers editing, query, and stored procedure contructors - I thought it might have a copy table or duplicate table feature.

sql

No comments:

Post a Comment