def do_schema(self, line):
        ''' .schema ?TABLE?        
Show the CREATE statements
    If TABLE specified, only show tables matching
    LIKE pattern TABLE.
'''
        try:
            res = self.cur.execute("SELECT * FROM sqlite_master ORDER BY name;")
            if not line:
                for row in res:
                    self.display(row['sql'])
            else:
                for row in res:
                    if row['tbl_name'] == line:
                        self.display(row['sql'])
        except:
            pass
 .schema ?TABLE?        
Show the CREATE statements
    If TABLE specified, only show tables matching
    LIKE pattern TABLE.

bin/sqlite.py