Is it possible to exclude certain tables and views from my database project in visual studio 2012 by template?

Question

I would like to be able to compare the schema between my Visual Studio 2012 database and the development or production database, however there are a number of dynamically created tables, and I would like to exclude them from the table / View Name Mask comparison. I.E. "TABLE_%" or "VIEW _%".

Does anyone know how I can achieve this with visual studio 2012? I could move these elements to another circuit if necessary, but it looks like I will have the same headache if I do.

Thanks in advance.

Answer 1

NOT LIKE ( SELECT * FROM Example WHERE Name LIKE "Joh_%" ) 

Not sure if he DOESN'T LIKE () or DOES NOT EXIST ()