Rename column SQL Server 2008
Posted By: Anonymous
I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL.
ALTER TABLE table_name RENAME COLUMN old_name to new_name;
This statement doesn’t work.
Solution
Use sp_rename
EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'
See: SQL SERVER – How to Rename a Column Name or Table Name
Documentation: sp_rename (Transact-SQL)
For your case it would be:
EXEC sp_RENAME 'table_name.old_name', 'new_name', 'COLUMN'
Remember to use single quotes to enclose your values.
Answered By: Anonymous
Related Articles
- What's the difference between eval, exec, and compile?
- How can I get column names from a table in SQL Server?
- How do I rename both a Git local and remote branch name?
- An Authentication object was not found in the…
- Python copy files to a new directory and rename if…
- Log record changes in SQL server in an audit table
- How do I fetch multiple columns for use in a cursor loop?
- Find a string by searching all tables in SQL Server…
- Find a value anywhere in a database
- Search all tables, all columns for a specific value…
- Search for one value in any column of any table…
- Drop all the tables, stored procedures, triggers,…
- How can I rename a conda environment?
- Rename a column in MySQL
- python 3.2 UnicodeEncodeError: 'charmap' codec can't…
- Difference between single and double quotes in Bash
- YAML: Do I need quotes for strings in YAML?
- Changing the maximum length of a varchar column?
- SMTP error 554
- SQL split values to multiple rows
- How to DROP multiple columns with a single ALTER…
- How to set variables in HIVE scripts
- How do I add a auto_increment primary key in SQL…
- Execution failed for task…
- What are the uses of the exec command in shell scripts?
- When to use single quotes, double quotes, and…
- how to show progress bar(circle) in an activity…
- Removing double quotes from variables in batch file…
- How do I rename a column in a SQLite database table?
- Best way to do multi-row insert in Oracle?
- How do you rename a MongoDB database?
- Generate SQL Create Scripts for existing tables with Query
- Android- Error:Execution failed for task…
- T-SQL: Export to new Excel file
- Change type of varchar field to integer: "cannot be…
- How can I parse a CSV string with JavaScript, which…
- Changing a specific column name in pandas DataFrame
- Adding an identity to an existing column
- What are the undocumented features and limitations…
- How to change a table name using an SQL query?
- SQL Client for Mac OS X that works with MS SQL Server
- Type datetime for input parameter in procedure
- How to rename a table in SQL Server?
- Persistent invalid graphics state error when using ggplot2
- Backbone routing regex
- including parameters in OPENQUERY
- MySQL: ALTER TABLE if column not exists
- Vue routes doesn't work
- Disable all table constraints in Oracle
- java.sql.SQLException: - ORA-01000: maximum open…
- How to take backup of a single table in a MySQL database?
- add column to mysql table if it does not exist
- Why does find -exec mv {} ./target/ + not work?
- How to check if a table exists in a given schema
- What is the difference between single-quoted and…
- How to convert an entire MySQL database characterset…
- ALTER DATABASE failed because a lock could not be…
- Rails: How can I rename a database column in a Ruby…
- insert a NOT NULL column to an existing table
- jQuery.parseJSON throws “Invalid JSON” error due to…
- Getting Checkbox Value in ASP.NET MVC 4
- Insert new column into table in sqlite?
- How to find out what is locking my tables?
- Postgresql : syntax error at or near "-"
- Multiple separate IF conditions in SQL Server
- MySQL 1062 - Duplicate entry '0' for key 'PRIMARY'
- How to get first two characters of a string in oracle query?
- Problems with local variable scope. How to solve it?
- How do I drop a foreign key constraint only if it…
- data.table vs dplyr: can one do something well the…
- Alter column, add default constraint
- CSS Input with width: 100% goes outside parent's bound
- Replacement for "rename" in dplyr
- Bash: Echoing a echo command with a variable in bash
- What is the difference between single and double…
- C error: Expected expression before int
- How do I use the CONCAT function in SQL Server 2008 R2?
- Is there a way to retrieve the view definition from…
- Add new column with foreign key constraint in one command
- Accessing an SQLite Database in Swift
- Simulating group_concat MySQL function in Microsoft…
- JSON.Parse,'Uncaught SyntaxError: Unexpected token o
- DROP IF EXISTS VS DROP?
- SQL Server, How to set auto increment after creating…
- SQL query return data from multiple tables
- Changing the JFrame title
- What does "Fatal error: Unexpectedly found nil while…
- How to check if a column exists before adding it to…
- Oracle: If Table Exists
- Sort table rows In Bootstrap
- Differences between fork and exec
- Fastest way to update 120 Million records
- Is it possible to insert multiple rows at a time in…
- How do I escape a string inside JavaScript code…
- Should MySQL have its timezone set to UTC?
- How to escape single quotes within single quoted strings
- postgresql - add boolean column to table set default
- How to use RANK() in SQL Server
- Search for a string in all tables, rows and columns of a DB
- List of foreign keys and the tables they reference…
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
