What happened to my table that I renamed using sp_rename?

  Kiến thức lập trình

I quickly reviewed the question and answer here: How to change a table name using an SQL query?

But I didn’t pay attention to the comments in the top answer that said to make sure and remove the schema from the second parameter.

So instead of runnning this:
EXEC sp_rename 'myschema.Stu_Table', 'Stu_Table_10'

I ran this:
EXEC sp_rename 'myschema.Stu_Table', 'myschema.Stu_Table_10'

Now I don’t see my table – where is it?

I tried refreshing the list of tables in SSMS but I don’t see any table resembling my original table. I tried looking for something like “dbo.dbo.Stu_Table_10” but I don’t see that either.

New contributor

Z Ali is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.


Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website