27-09-17, 11:43 AM
الرجاء رؤية الاكواد هل هي صحيحة او في شيء غلط ؟
كود :
conn.Open()
Using cmd As New OleDbCommand("DROP Index PrimaryKey ON Customer", conn)
End Using
Using cmd As New OleDbCommand("ALTER TABLE Customer DROP COLUMN Cus_ID", conn)
End Using
Using cmd As New OleDbCommand("alter table Customer ADD Cus_ID int identity", conn)
End Using
Using cmd As New OleDbCommand("ALTER TABLE Customer ADD PRIMARY KEY (Cus_ID)", conn)
cmd.ExecuteNonQuery()
End Using
conn.Close()
