Add new field in every table (100 tables)

Hi All,



I inherited an old database. Not designed too well. Nearly 100 tables with different types of names. Some table names start with and "_", some with "tbl" and some just names.



I want to add a new field called "TimeStamp", date/time, and default value Now() to all the tables. Any pointers would be of help.



:confused:



Thanks in advance.



Raghu Prabhu

Add new field in every table (100 tables)