• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

VB.net Duplicate a SQL table

Hi

What VB.net code would I use to duplicate an SQL table using
SQL Client style of coding similar to the following:

            Dim myConnection As SqlConnection = New SqlConnection(Globals.ThisAddIn.oRIGHT.lblConnectionString.Text)
            Dim myCommand As SqlCommand

            Dim ra As Integer

            Dim sSQL As String = "ALTER TABLE [" & oTable & "] DROP COLUMN [" & oColumn & "]"


            myConnection.Open()

            myCommand = New SqlCommand(sSQL, myConnection)
            ra = myCommand.ExecuteNonQuery()

            DropColumnSQL = True

            myConnection.Close()
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
ButlerTechnologyCommented:
The following TSQL will duplicate a table structure without putting any data in it.
Select *
into EmployeeCopy
from Employee
where empID = 0

Open in new window

This does only the basic structure.  It will not duplicate the primary key constraint.

Tom
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now