<p>I tried the following code. Although I don't get any errors, it did not do it.</p> <pre class="prettyprint"><code>SELECT * FROM Categories EXEC sp_rename 'Active', CategoriesActive </code></pre>

<pre class="prettyprint"><code>EXEC sp_rename 'Categories.Active', 'CategoriesActive', 'COLUMN' </code></pre>

Rename column in SQL Server

I tried the following code. Although I don't get any errors, it did not do it.

SELECT * FROM Categories EXEC sp_rename 'Active', CategoriesActive

431

asked Mar 15 '10 15:03

EXEC sp_rename 'Categories.Active', 'CategoriesActive', 'COLUMN'

answered Sep 30 '22 09:09

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!