Renaming Tables and Columns in SQL Server

Renaming Tables and Columns in SQL Server

Changing table or colum in SQL Server is as follows,
To change the name of the table:
sp_RENAME ‘tbloldname’, ‘tblnewname’;
To chagne the name of the column:
sp_RENAME ‘tbl.columnoldname’,’columnnewname’,’COLUMN’;

** You might face a problem on changing names of enforced (integrity) columns.

Force redirect http to https using htaccess

You don’t have permission to access / on this server. Apache error

Apache Not Service Files from Icons Folder

Create Tables From Entity Definitions From JPA Spring

spring error ClassNotFoundException org.springframework.web.context.ContextLoaderList

The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*