You can use undocumented sp_MSforeachtable
EXEC sp_MSforeachtable @command1="ALTER TABLE ? ..."
>Not quite clear on proper syntax for a script to add a timestamp field to all tables in a database.
>
>( working on my vfpdata to sql upsizer )
>
>I can figure out the single table script from just generating a change script, but not sure
>about the loop. Guidance appreciated.
>
>TIA
--sb--