>Hi !
>
>Pls help me to alter the data type of a field of all the tables exist in the SQL Database.
>
>Thanks In Advance
>Ravi
In ALL tables you have the same field?
Try this:
USE YourDataBase
GO
EXEC sp_MSForEachTable 'ALTER TABLE ? ALTER COLUMN TheNameOfTheColumn (rest of the ALTER COLUMN syntax)'
GO
NOT TESTED!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.