creating a new table in DataBase

[lai]

hello,
i need to read data from a table call tabA in a DataBase and create another table call tabB during runtime in the same DB. tabB will contain the duplicate data of tabA. Can anyone post me the code to do it.

Thanks in advance.

[dinesh123]

Dim InsertCmdString As String
InsertCmdString = "Create Table TAB"
Dim mySqlCommand As SqlCommand = New SqlCommand(InsertCmdString, myConnection)

Dim InsertCmdString As String
InsertCmdString = "Insert into TaB From TAA"
Dim mySqlCommand As SqlCommand = New SqlCommand(InsertCmdString, myConnection)