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
1