SQL query for alter and modify

SQL query for alter and modify if we want to change in structure of table like product this is DDL command

modify