Owner: | dbo |
Schema bound: | |
Encrypted: | |
Creation Date: | 08/06/2000 |
Description: |
Name | Data Type | Length | NULL | IsGUID | Description | |
|
CustomerID | nchar | 10 |
|
|
|
|
CompanyName | nvarchar | 80 |
|
|
|
|
City | nvarchar | 30 |
|
|
|
|
Country | nvarchar | 30 |
|
|
Objects that [dbo].[Quarterly Orders] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Customers | dbo | Table | 1 |
|
Employees | dbo | Table | 1 |
|
Shippers | dbo | Table | 1 |
|
Orders | dbo | Table | 2 |
create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'
See Also
List of views