<div>
You could build some dynamic code to get all tables not in schema like<br />
<br />
<br />
--find all tables in schema<br />
select so.name --* <br />
from &nbsp;sys.objects so inner join sys.schemas ss on so.schema_id = ss.schema_id<br />
where ss.name not in('LTW','PTO')<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and so.type = 'U' -- user table<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
then loop trhough the set and create/execute a DROP TABLE command.
</div>


You could build some dynamic code to get all tables not in schema like


--find all tables in schema
select so.name --*
from  sys.objects so inner join sys.schemas ss on so.schema_id = ss.schema_id
where ss.name not in('LTW','PTO')
      and so.type = 'U' -- user table
      

then loop trhough the set and create/execute a DROP TABLE command.

<div>
<div class="content wysiwyg-content">
there are 10 schemas in a backup file.. after the restore, though, we want to only the tables from 2 schemas.. <br />
<br />
after restore, what could be a simple script to drop all the tables that dont belong to those 2 (LTW &amp;&nbsp;PTO) schemas?<br />
<br />
<br />
<br />
thanks
</div>
</div>


there are 10 schemas in a backup file.. after the restore, though, we want to only the tables from 2 schemas.. 

after restore, what could be a simple script to drop all the tables that dont belong to those 2 (LTW & PTO) schemas?



thanks

keep only certain schema tables from a restore

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.