Friday, September 18, 2009

To change column name of a table

SP_RENAME 'TableName.OldColumnName', 'NewColumnName', 'COLUMN'

eg.
SP_RENAME 'student.marks', 'total_marks', 'COLUMN'
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)