ALTER TABLE gnumber ADD USERS varchar(8) '0' This would add a field or column named USERS to table gnumber type would be varchar(8)
