Read-only Back to SQLite3 Guide
Northwind › Views
Invoices view

2155 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.

Data Structure
Columns
PRAGMA table_info
#NameTypeNot nullDefaultKeyReferences
0 ShipName TEXT no —
1 ShipAddress TEXT no —
2 ShipCity TEXT no —
3 ShipRegion TEXT no —
4 ShipPostalCode TEXT no —
5 ShipCountry TEXT no —
6 CustomerID TEXT no —
7 CustomerName TEXT no —
8 Address TEXT no —
9 City TEXT no —
10 Region TEXT no —
11 PostalCode TEXT no —
12 Country TEXT no —
13 Salesperson (none) no —
14 OrderID INTEGER no —
15 OrderDate TEXT no —
16 RequiredDate TEXT no —
17 ShippedDate TEXT no —
18 ShipperName TEXT no —
19 ProductID INTEGER no —
20 ProductName TEXT no —
21 UnitPrice REAL no —
22 Quantity INTEGER no —
23 Discount REAL no —
24 ExtendedPrice (none) no —
25 Freight REAL no —
Definition
from sqlite_schema
CREATE VIEW Invoices AS SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country, Employees.FirstName || ' ' || Employees.LastName AS Salesperson, Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName AS ShipperName, "Order Details".ProductID, Products.ProductName, "Order Details".UnitPrice, "Order Details".Quantity, "Order Details".Discount, round("Order Details".UnitPrice * Quantity * (1 - Discount), 2) AS ExtendedPrice, Orders.Freight FROM Orders INNER JOIN Customers ON Customers.CustomerID = Orders.CustomerID INNER JOIN Employees ON Employees.EmployeeID = Orders.EmployeeID INNER JOIN Shippers ON Shippers.ShipperID = Orders.ShipVia INNER JOIN "Order Details" ON "Order Details".OrderID = Orders.OrderID INNER JOIN Products ON Products.ProductID = "Order Details".ProductID