ALTER TABLE `visitors` ADD `campus_transfer` BINARY(2) NOT NULL AFTER `visitor_type`; code example

Example: Change A filed to not null

ALTER TABLE
  clients
ALTER COLUMN
  phone
    NVARCHAR(20) NOT NULL;