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.
Get maximum occurring character
Flatten nested javascript array
Implement Queue Using two Stacks – JavaScript algorithm
Update Node and npm on mac OSX
Tunneling to AWS instance using pem file