Hi every one . I'm beginner in VB . I want to delete a column in my DataBase(DB2) , and write this command for delete

Dim conn As DB2Connection = New DB2Connection("database=tut8;UID=;PWD=")
Dim myCommand As New DB2Command
Dim sql1 As String
sql1 = "delete from student where id = ('" & TextBox1.Text & "')"
conn.Open()
myCommand.Connection = conn
myCommand.CommandText = sql1
myCommand.ExecuteNonQuery()
conn.Close()

my problem this when i want to delete this command, just delete last row that i enter with command insert

the SQL DELETE command deletes rows, not columns. To remove a column, you will need to use the SQL ALTER TABLE DROP COLUMN xxxxx statement.

In looking at the documentation, it isn't clear if you are allowed to drop columns in DB2. If not, you'll need to create a new table without the offending column, populate the new table with data from the existing table, then kill the old table, and rename the new table with the old table name.