.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
- SharePoint 2010 Tutorials For Beginners Lession 4 : Introduction to Web Parts
- SharePoint 2010 Tutorials For Beginners Lession 3:Document Libraries
- SharePoint 2010 Tutorials For Beginners Lession 2
- SharePoint 2010 Tutorials For Beginners Lession 1
- Sharepoint Tutorial - What is sharepoint 2010 , sharepoint foundation 2010 and sharepoint server 2010 ?
- ASP.NET and .NET Interview question : What is Authentication and Authorization ?
- Bind ComboBox With Relation to each other's | Bind combobox to combobox | populate a combo box Using C#
- 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
