Common DB2 data commands

Common DB2 data commands
When writing SQL scripts for DB2 databases, you must add ";" eg: ------------------------------------ the script starts ------------------------------; -- delete the field alter table db2inst1 In the DB2 database table. student drop column age; -- alter table db2inst1. student alter name set data type varchar (100); -- the alter table db2inst1 field is added to the student table of the DB2 database. student add column class varchar (30); -------------------------------- script end -------------------------------------------- db2inst1 is the schema of the db2 database. The schema to be modified is added before the table name