I have a shared SQL with a remote host ISP. I created all the tables with a script but a few of them I did not stipulate 'dbo.CreateProcedure' so it created the table with my login as the owner or schema. Those specific tables now need to be accessed via their name as they are not dbo.xzcxz, What is the correct syntax for a procedure to change their schema all to dbo.
For example I want to change
I hope I have explained it fully.
Abiel M de Groot Sanders
PS. I will be out of the office tomorrow.