Mithilesh_SQL

Mithilesh_SQL

Share

To enhance Programming skills in iOS,Swift, .net ,sql and crystal report.............

24/07/2014

Renaming existing column in sql

sp_rename '[tablename.oldcolumnname]','[newColumnName]','COLUMN'

Example :-
sp_rename 'employee.empid','emplooyeeID','COLUMN'

24/07/2014

Creating Primary key constraint on existing column...

ALTER TABLE Employee ADD CONSTRAINT pkEmpID PRIMARY KEY (EmpId)

Want your business to be the top-listed Computer & Electronics Service in Delhi?
Click here to claim your Sponsored Listing.

Telephone

Website

Address


Delhi
110003