Owner: | dbo |
Schema bound: | |
Encrypted: | |
Creation Date: | 08/06/2000 |
Description: |
Name | Data Type | Length | NULL | IsGUID | Description | |
|
OrderID | int | 4 |
|
|
|
|
ProductID | int | 4 |
|
|
|
|
ProductName | nvarchar | 80 |
|
|
|
|
UnitPrice | money | 8 |
|
|
|
|
Quantity | smallint | 2 |
|
|
|
|
Discount | real | 4 |
|
|
|
|
ExtendedPrice | money | 8 |
|
|
Objects that [dbo].[Order Details Extended] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Categories | dbo | Table | 1 |
|
Customers | dbo | Table | 1 |
|
Employees | dbo | Table | 1 |
|
Shippers | dbo | Table | 1 |
|
Suppliers | dbo | Table | 1 |
|
Orders | dbo | Table | 2 |
|
Products | dbo | Table | 2 |
|
Order Details | dbo | Table | 3 |
Objects that depend on [dbo].[Order Details Extended]
Object Name | Owner | Object Type | Dep Level | |
|
Sales by Category | dbo | View | 1 |
create view "Order Details Extended" AS
SELECT "Order Details".OrderID, "Order Details".ProductID, Products.ProductName,
"Order Details".UnitPrice, "Order Details".Quantity, "Order Details".Discount,
(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice
FROM Products INNER JOIN "Order Details" ON Products.ProductID = "Order Details".ProductID
--ORDER BY "Order Details".OrderID
See Also
List of views