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