CODE EXAMPLE FOR SQL

changing name of column and datatype in sql

ALTER TABLE supplier
  CHANGE COLUMN supplier_name sname VARCHAR(100);