How to rename something in SQL Server that has square brackets in the name?

by

You do it the same way you do to create it:

exec sp_rename 'BookPublisher."[Book_Category]"', 'Book_Category', 'COLUMN';

Here’s a little sample I made to test if this was even possible. At first I just assumed it was a misunderstanding of how [] can be used in SQL Server, turns out I was wrong, it is possible – you have to use double quotes to outside of the brackets.

begin tran

create table [Foo] ("[i]" int);

exec sp_help 'Foo';

exec sp_rename 'Foo."[i]"', 'i', 'column ';

exec sp_help 'Foo';

rollback tran

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  3. sql server 2008 management studio not checking the syntax of my query
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. How to create a table from select query result in SQL Server 2008 [duplicate]
  6. Where value in column containing comma delimited values
  7. Parse comma-separated string to make IN List of strings in the Where clause
  8. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  9. OPTION (RECOMPILE) is Always Faster; Why?
  10. Rename column SQL Server 2008
  11. Transfer data from one database to another database
  12. Compare DATETIME and DATE ignoring time portion
  13. Split function in SQL Server 2008
  14. Remove numbers from string sql server
  15. How to find third or nᵗʰ maximum salary from salary table?
  16. SQL “between” not inclusive
  17. Can I set ignore_dup_key on for a primary key?
  18. Selecting first row per group
  19. How do I edit a table in order to enable CASCADE DELETE?
  20. sql group by only rows which are in sequence
  21. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  22. SQL Server SELECT LAST N Rows
  23. Converting Select results into Insert script – SQL Server
  24. How to retrieve field names from temporary table (SQL Server 2008)
  25. How to combine results of two queries into a single dataset
  26. When using GETDATE() in many places, is it better to use a variable?
  27. How to execute a stored procedure inside a select query
  28. Using CASE Statement inside IN Clause
  29. Single or multiple databases
  30. SQL Unpivot multiple columns Data

Leave a Comment