Schema Introspection with PRAGMA
Advanced
Tools such as ORMs, migration scripts and admin screens need to ask the database about its own structure: which columns does a table have, what types are they, which one is the primary key? SQLite answers through PRAGMA commands, and many of them can also be used like tables inside a query.
Write a query that lists the structure of the orders table by reading pragma_table_info('orders'): return name, type, "notnull" and pk for every column.
Constraints
- Columns, in order:
name,type,notnull,pk - Read from
pragma_table_info('orders') - One row per column of
orders
Hints
Hint 1
SELECT ... FROM pragma_table_info('orders') works like a table.
Hint 2
notnull is also a keyword, so quote it: "notnull".
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.