.gif)
There are always cases when we believe certain names are perfect for columnname or tablename but as time passes and needs are changed. We can use SP_RENAME stored procedure to change the name of the column or table. Though, one has to make sure that all the places where the name is used in the code also reflects the new name as well.
Sql,
Video Tutorial
»
Rename Columnname or Tablename
Rename Columnname or Tablename
Related Posts: Sql,
Video Tutorial
- Asp.Net Example : ASP.NET Validation Controls
- Insert, update and delete (C#) : SqlServer
- XML Data Type Methods in SQL Server 2005
- Replace SELECT * with Column Names - SQL SERVER
- Importing CSV into SQL Server - SQL SERVER
- Comment T-SQL in SQL Server Management Studio - SQL SERVER
- Generate Script for Schema and Data in SQL Server - SQL SERVER
- Methods to Insert Multiple Rows into Single Table - SQL SERVER
- Get Date and Time From Current DateTime - SQL
- Identify Most Resource Intensive Queries - SQL
- Query to Find Row and Index Count of Database Tables
- Resolving SQL Server Connection Errors
- Copy Data from One Table to Another Table-SQL
- Rename Columnname or Tablename
- Display Datetime in Specific Format
- Auto Recovery File Settings in SSMS
- Concat Strings in SQL Server using T-SQL
- SQL SERVER – Find Nth Highest Salary of Employee –Query to Find 2nd or 3rd highest salary of employee in SQL Server
- SQL SERVER – Get Comma Separated Values (CSV) from Table Column
- SQL SERVER –Query To Find Recently Executed T-SQL Query
