rename columnName and change column's data typ

2019-07-12 08:58发布

问题:

how can I by using Ado.net rename existing column in a table and changing a column's data type?

回答1:

You can call stored procedure for that, as follows

EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName'

see section: Renaming a Column in this Article