The .schema command displays the SQL commands used
to create the schema (tables, views, indexes, etc.). If no
parameter is given, the CREATE command for every object in the main and temp databases will be
displayed. A single parameter can also be given, in which case
only those objects associated with tables that match the
LIKE pattern will be
displayed.