Hi Guys pls help.
how can I add a new column to more than 500 tables in a database,
I have return all the table name from the DB into a ListBox,
Now I want to loop into that ListBox adding a column to the table,
I actually want to automate a SQl script for adding that column
using this commnd:
ALTER TABLE table
{ [ ALTER COLUMN column_name
{ new_data_type [ ( precision [ , scale ] ) ]
[ COLLATE ]
[ NULL | NOT NULL ]
| {ADD | DROP } ROWGUIDCOL }
]
pls help!!!!