loviji
Reputation: 13080
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 table and changing a column's data type?
Upvotes: 2
Views: 2202
Answers (1)
Asad
Reputation: 21928
You can call stored procedure for that, as follows
EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName'
see section: Renaming a Column in this Article
Upvotes: 2
Related Questions
- How to change column from one data type to antother using script
- How to change column type in sql server 2008
- Alter column Datatype
- How to update the data type of same name multiple columns
- What is the proper procedure to rename columns in an MSSQL Database via VB.NET?
- Update column data type and update the data
- Change the data type of a table column in SQL Server 2008
- rename column without changing its type
- Changing the Datatype of table column
- Alter column datatype in sql