Alter Table

[HLPCH]

Hi

I want to Alter couple of tables and add a new column "Lastupdated". Here' what I did.

Create Procedure [Sample]
As

ALTER TABLE[Test] ADD LastUpdated DateTime NULL
go
ALTER TABLE[Test1] ADD LastUpdated DateTime NULL
go
ALTER TABLE[Test2] ADD LastUpdated DateTime NULL

Go

The above gives me an error that 'LAstupdated' is already used in table Test hence I cannot sue the same name for rest of the tables.

could someone help me on this? I want to add a new colum to the tables using a single Stored Procedure.

Thanks

 

[HLPCH]

Hi, I found the problem. These fields were already defined in the table. so please ignore this post.

Thanks

Hlpch