title: Renaming multiple tables
body: <p>In SQL Server, I have a database <code>abc</code>. In this database I have hundreds of tables. Each of these tables is called <code>xyz.table</code></p>
  
  <p>I want to change all the tables to be called <code>abc.table</code>.</p>
  
  <p>Do we have a way by which I can change all the names from <code>xyz.table</code> to <code>abc.table</code> in database <code>abc</code>?</p>
  
  <p>I am able to manually change the name by changing the schema for each table to abc</p>