rename columnName and change column's data type in a table by using ADO.NET
how can I by using Ado.net rename existing column in a ta开发者_Python百科ble and changing a column's data type?
You can call stored procedure for that, as follows
EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName'
see section: Renaming a Column
in this Article
精彩评论