Owner: | dbo |
Schema bound: | |
Encrypted: | |
Creation Date: | 08/06/2000 |
Description: |
Name | Data Type | Length | NULL | IsGUID | Description | |
|
City | nvarchar | 30 |
|
|
|
|
CompanyName | nvarchar | 80 |
|
|
|
|
ContactName | nvarchar | 60 |
|
|
|
|
Relationship | varchar | 9 |
|
|
Objects that [dbo].[Customer and Suppliers by City] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Customers | dbo | Table | 1 |
|
Suppliers | dbo | Table | 1 |
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