Properties

Owner: dbo 
Schema bound:  
Encrypted:  
Creation Date: 08/06/2000 
Description:  

Columns

Name Data Type Length NULL IsGUID Description
  City  nvarchar  30       
  CompanyName  nvarchar  80       
  ContactName  nvarchar  60       
  Relationship  varchar       
Total: 4 column(s)

Objects that [dbo].[Customer and Suppliers by City] depends on

Object Name Owner Object Type Dep Level
  Customers  dbo  Table 
  Suppliers  dbo  Table 
Total: 2 objects

SQL

create view "Customer and Suppliers by City" AS
SELECT City, CompanyName, ContactName, 'Customers' AS Relationship
FROM Customers
UNION SELECT City, CompanyName, ContactName, 'Suppliers'
FROM Suppliers
--ORDER BY City, CompanyName

See Also

List of views