skip to main | skip to sidebar

ASP.NET / SQLSERVER

All I have learned.

Wednesday, June 18, 2008

Rename database table column SQL Server

Execute below statemnet in SQL analyzer and it will rename the column name.

exec sp_rename 'DBO.Customers.CompanyName', 'CorporateName', 'COLUMN'
Posted by Madhusudan Gohil at 6:59 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2014 (1)
    • ►  March (1)
  • ►  2009 (5)
    • ►  September (2)
    • ►  March (2)
    • ►  January (1)
  • ▼  2008 (12)
    • ►  November (1)
    • ►  August (6)
    • ►  July (1)
    • ▼  June (4)
      • Reading resources from resource dll of another app...
      • Rename database table column SQL Server
      • ASP.NET Control Access Key, AssociatedControlID an...
      • Reading from Resources.dll in ASP.NET
  • ►  2007 (45)
    • ►  December (5)
    • ►  November (11)
    • ►  October (12)
    • ►  May (1)
    • ►  April (7)
    • ►  March (9)

About Me

Madhusudan Gohil
Systems Analyst
View my complete profile