If you want to know what is the query corresponding to the change you’ve done to a table (or other object) in designer mode, use Generate Change Script (Table Designer → Generate Change Script… or the very first icon, with a diskette and a script, in Table Designer toolbar) command.