SQL Server - rename columns

Question

I'm trying to rename a few columns within a table that's already created:

  USE AdventureWorks
  GO

  EXEC sp_RENAME 'registration.StudentID', 'Temp', 'COLUMN';
  GO

But I'm getting this error message:

Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.

If I omit 'COLUMN', this error appears:

No item by the name of 'registration.StudentID' could be found in the current database 'AdventureWorks', given that @itemtype was input as '(null)'.

I'm pretty sure that the StudentID column exists and has data in there. Can anyone help me out? Thanks!!!

I see in your first version you had registration.dbo.Enrollment.StudentID, Can you clarify the database, schema, table and column names? — Martin Smith
– Martin Smith, Commented Nov 14, 2012 at 8:12
for sure, I made a typo earlier. database-registration, schema-dbo, table-enrollment, column-StudentID — zoe
– zoe, Commented Nov 14, 2012 at 8:37
So you should have use registration not use AdventureWorks and exec sp_rename 'dbo.enrollment.StudentID', 'Temp', 'COLUMN'; then — Martin Smith
– Martin Smith, Commented Nov 14, 2012 at 8:50

Martin Smith · Accepted Answer · 2012-11-14 08:52:26Z

4

Based on the comments this is what you need.

USE registration;

EXEC sp_rename 'dbo.enrollment.StudentID', 'Temp', 'COLUMN';

edited Nov 14, 2012 at 8:52

answered Nov 14, 2012 at 8:03

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AMH · Accepted Answer · 2012-11-14 07:31:54Z

0

the correct call is

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

so I think ur code should be

USE AdventureWorks
  GO
  EXEC sp_RENAME '[registration].StudentID', 'Temp', 'COLUMN';

  Go

answered Nov 14, 2012 at 7:31

AMH

6,47127 gold badges86 silver badges137 bronze badges

3 Comments

zoe Over a year ago

thanks for ur reply AMH!! I tried both '[registration].StudentID', 'Temp', 'COLUMN'; and 'registration.[StudentID]', '[Temp]', 'COLUMN'; but still getting the same error..

AMH Over a year ago

are u sure of the column name

AMH Over a year ago

ok try the accepted answer on stackoverflow.com/questions/5330070/…

Collectives™ on Stack Overflow

SQL Server - rename columns

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related