Updating column name in sql

You can bring up the table in design mode, but the right to actually design or change it has been removed.

sp_rename automatically renames the associated index whenever a PRIMARY KEY or UNIQUE constraint is renamed.

updating column name in sql-2

Would you like to answer one of these unanswered questions instead?

If I wish to simply rename a column (not change its type or constraints, just its name) in an SQL database using SQL, how do I do that? This is for any database claiming to support SQL, I'm simply looking for an SQL-specific query that will work regardless of actual database implementation.

For a complete reference of all the data types available in MS Access, My SQL, and SQL Server, go to our complete Data Types reference.

Rename Column Syntax Sometimes we want to change the name of a column.

If a renamed index is tied to a PRIMARY KEY constraint, the PRIMARY KEY constraint is also automatically renamed by sp_rename.

sp_rename can be used to rename primary and secondary XML indexes.

We've also added some practice exercises that you can try for yourself.

That is a good answer, but where I am currently employed, they have turned off the security to be able to do this.

if exists (select 1 from sys.columns where name = 'Old Column Name' and object_name(object_id) = 'Table Name') AND not exists (select 1 from sys.columns where name = 'New Column Name' and object_name(object_id) = 'Table Name') EXEC sp_RENAME 'Schema Name. Old Column Name', 'New Column Name', 'COLUMN'; Thank you for your interest in this question.

Tags: , ,