VB6 SP5; ADOX v2.7; SQLOLEDB provider
I would like to know if it's possible to use ADOX in VB to
rename an existing column of an existing table in SQL Server
2000, and also, any limitations or caveats related to renaming
an existing field.
When I try setting ADOXcolumn.Name = "something", I get a
run-time error 3251 "Object or provider is not capable of
performing requested operation."
I thought for sure that I have done this before, but am not certain.
Also, I read Microsoft's MSDN library article on the ADOX
"Name" property, and did see that it was read/write. I also checked
the SQLOLEDB limitations page, and did not see anything about
renaming an existing field...
I do know about SQL-DMO, but was curious if this could be done
Any thoughts would be great... thanks-