I need to add a field called corporateID (Integer) with a default value of 0 to every table in my sql database. But I have never actually coded an Alter command. I know I can get a list of all tables with one of the sql() commands in VFP, then I could just scan through those and issue the alter. I was hoping someone could help me format the alter command.

Thanks
Kirk