How can I solve Either the parameter objname is ambiguous or the claimed objtype COLUMN is wrong

Question

If I try to execute below query   EXEC sp rename  ENG TEst  ENG Test A C TYPE     ENG Test AC TYPE    COLUMN    I get an error       Either the parameter objname is   ambiguous or the claimed  objtype    COLUMN  is wrong    How can I solve it

User · Answer

I got this error when Updating code first MVC5 database  Dropping  right click  delete  all the tables from my database and removing the migrations from the Migration folder worked for me

User · Answer

just try to remove the STATISTICS INDEXES linked to this COLUMN   Best Regards

User · Answer

Nuts  I hit this same error weeks ago  and after a lot of wasted time figured out how to make it work--but I ve since forgotten it   Not much help  other than to say yes  it can be done    Have you tried different combinations of brackets  or of with and without brackest  e g   EXEC sp rename  ENG TEst ENG Test A C TYPE    ENG Test AC TYPE    COLUMN   EXEC sp rename   ENG TEst   ENG Test A C TYPE     ENG Test AC TYPE    COLUMN   EXEC sp rename   ENG TEst   ENG Test A C TYPE      ENG Test AC TYPE     COLUMN   EXEC sp rename   ENG TEst  ENG Test A C TYPE    ENG Test AC TYPE    COLUMN     If all else fails  there s always    Create new table  as  xENG TEst   with proper names Copy data over from old table Drop old table Rename new table to final name

User · Answer

Are you running the query in the correct database  i e    Use MyDatabase  GO EXEC sp rename  ENG TEst  ENG Test A C TYPE     ENG Test AC TYPE    COLUMN   GO

User · Answer

Both of the following work  as discussed here    exec sp rename  ENG TEst   ENG Test A C TYPE                         ENG Test A C TYPE    COLUMN    exec sp rename  ENG TEst   ENG Test A C TYPE                        ENG Test A C TYPE    COLUMN

User · Answer

I tried every possible solution on this web site and nothing worked for me  I ended up doing in the design mode  Right click on the table name and then click design  Then I changed the name and saved here  Worked simply

User · Answer

i also had this issue- very annoying and haven t found a satisfactory sql answer myself yet  aside from long-winded ones involving creating temp tables etc   and i didn t have time to explore it to the conclusion i d have liked   In the end just used SQL Server Management Studio to do it by selecting the table  right-clicking on the column and hitting rename  simples   obviously i d rather know how to do it without a gui but sometimes you ve just gotta get sh   done

User · Answer

I ran into this today and got it to work with   EXECUTE sp rename N dbo table name original field name   N new field name    COLUMN     To get this syntax  I followed Martin Smith s advice above - open up the table in design view  rename the column and then click table designer   generate change script   This produced the script below which does the renaming in two steps      To prevent any potential data loss issues  you should review this script in    detail before running it outside the context of the database designer    BEGIN TRANSACTION SET QUOTED IDENTIFIER ON SET ARITHABORT ON SET NUMERIC ROUNDABORT OFF SET CONCAT NULL YIELDS NULL ON SET ANSI NULLS ON SET ANSI PADDING ON SET ANSI WARNINGS ON COMMIT BEGIN TRANSACTION GO EXECUTE sp rename N dbo table name original field name   N Tmp new field name 1   COLUMN   GO EXECUTE sp rename N dbo table name Tmp new field name 1   N new field name    COLUMN   GO ALTER TABLE dbo table name SET  LOCK ESCALATION   TABLE  GO COMMIT

User · Answer

This works  EXEC sp rename   objname    ENG TEst   ENG Test A C TYPE       newname    ENG Test A C TYPE     objtype    COLUMN

[sql] How can I solve "Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong."?

Examples related to sql

Examples related to sql-server