i think u can try to Select from Table1 1st then put it in a String, after that only you drop the column.
sample table
this is sample code using VB
Code:
Dim strSQL As String = ""
Dim strColumnToDrop As String = ""
strConnection = 'your connection string
sqlConn = New SqlConnection(strConnection)
'Select Data
Leave a comment: