If the column appears only in one of the referenced tables, you don’t need to include the fully qualified name, but it may be useful to do so for readability. Must-read developer coverage ...

Adds columns to, drops columns from, and changes column attributes in an existing table. Adds, modifies, and drops integrity constraints from an existing table. Restriction: You cannot use any type of ...