Hi Mokles
Have you tried to rename the field using sp_rename.
Enterprise manager does the job using same kind of scripts but its not
intelligent enough I have observed in various scenarios that sometimes
it accomplishes simple tasks using long approach.
I wonder if there are any indexes on the table ?
Regards
Shehzad
[quoted text, click to view] "mokles" <mokles@rogers.com> wrote in message news:<wIGdnaGM46YtX_jcRVn-oA@rogers.com>...
> Hi All,
> I am trying to change column name on an existing table. I am using SQL
> Server 7.
>
> As the table is quite big, it is taking quite long time to do it.
> By the way I could change the column name only through the Enterprize
> Manager.
>
> Is it possible to change the column name using SQL script?
> Why the change of column name will depend on the size of the table?
>
> Thanks for your answer.
>
You can change a column name using sp_rename.
EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName', 'COLUMN'
See the Books Online for more information.
--
Hope this helps.
Dan Guzman
SQL Server MVP
[quoted text, click to view] "mokles" <mokles@rogers.com> wrote in message
news:wIGdnaGM46YtX_jcRVn-oA@rogers.com...
> Hi All,
> I am trying to change column name on an existing table. I am using SQL
> Server 7.
>
> As the table is quite big, it is taking quite long time to do it.
> By the way I could change the column name only through the Enterprize
> Manager.
>
> Is it possible to change the column name using SQL script?
> Why the change of column name will depend on the size of the table?
>
> Thanks for your answer.
>
> -Mokles
>
>
Today I tried to do it with sp_Rename and it worked well and fast.
Previously I was using profiler to see what the Enterprize Manager was
doing. And really it was using complicated method to change the column name.
Thanks all for the help
-Mokles
[quoted text, click to view] "Shehzad Shabbir" <shehzad@internav.com> wrote in message
news:503e40d5.0410071952.643d25ee@posting.google.com...
> Hi Mokles
>
> Have you tried to rename the field using sp_rename.
>
> Enterprise manager does the job using same kind of scripts but its not
> intelligent enough I have observed in various scenarios that sometimes
> it accomplishes simple tasks using long approach.
>
> I wonder if there are any indexes on the table ?
>
> Regards
> Shehzad
>
>
> "mokles" <mokles@rogers.com> wrote in message
news:<wIGdnaGM46YtX_jcRVn-oA@rogers.com>...
> > Hi All,
> > I am trying to change column name on an existing table. I am using SQL
> > Server 7.
> >
> > As the table is quite big, it is taking quite long time to do it.
> > By the way I could change the column name only through the Enterprize
> > Manager.
> >
> > Is it possible to change the column name using SQL script?
> > Why the change of column name will depend on the size of the table?
> >
> > Thanks for your answer.
> >
> > -Mokles
I could do it using Sp_Rename.
Enterprize Manager was using complicated method to do the simple task
Anyway thanks for the help
-Mokles
[quoted text, click to view] "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:6Qk9d.2605$Al3.1466@newssvr30.news.prodigy.com...
> You can change a column name using sp_rename.
>
> EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName', 'COLUMN'
>
> See the Books Online for more information.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "mokles" <mokles@rogers.com> wrote in message
> news:wIGdnaGM46YtX_jcRVn-oA@rogers.com...
> > Hi All,
> > I am trying to change column name on an existing table. I am using SQL
> > Server 7.
> >
> > As the table is quite big, it is taking quite long time to do it.
> > By the way I could change the column name only through the Enterprize
> > Manager.
> >
> > Is it possible to change the column name using SQL script?
> > Why the change of column name will depend on the size of the table?
> >
> > Thanks for your answer.
> >
> > -Mokles
> >
> >
>
>
