ekekakos wrote:
> Hello, I would like to create with several tables but each table will have 2
> fields, LASTUSERID & LASTUPDATEDATETIME. My quest is:
> Is there any way to create these 2 fields and then use them in all tables?
>
> Please help the soonest table.
> Thanks in advance
> Elias
No. Perhaps you were thinking you could create a table w/ these two
columns and then alter your other tables to inherit that table. But I
don't think that's a great idea and those columns already have to exist
in the child tables in order to be able to alter the inheritance.
You'll have to add the columns manually. You should be able to write a
function in a few minutes that walks a cursor and adds them to each
table in a given schema.
Scott Bailey