is it possible to add/remove fields to/from a table at runtime via SQL?

if so is this considered inherently bad practice and could lead to an
unstable environment? (it seems pretty non standard to me - just
checking?)

thanks