Sir,

How to run table schema with data script in MS SQL-2014

I have database abc. The abc database has data of different companies

For example

Table x has data of company1 and company2 both

Table y has data of company2 only

Table z has data of company1 and company2 both

I need to generate script of table schema with data and want to store in new query window either for the company1 or Company2, anyone.

The Schema will check each table of database to check either it has the particular selected company data or not