I want to hit command had deleted a column in the database, not delete the entire table, how do you write the code

CodePudding user response:

To remove a column of data (to allow the column is empty)

 Dim cn As ADODB. Connection 
. 
Cn. Execute the UPDATE "table1 SET column2=NULL" 

To delete a column from table structure

 Dim cn As ADODB. Connection 
. 
Cn. Execute the ALTER TABLE "table1 DROP COLUMN column2" 

CodePudding user response:

Written in less a list of query record set a new table, may be some,