SELECT * FROM sqlite_master WHERE type = "table";

type name tbl_name rootpage sql
table Autoren Autoren 2 CREATE TABLE Autoren (AutorID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE, Name VARCHAR(40), Beschreibung VARCHAR(255), Homepage VARCHAR(100))
table sqlite_sequence sqlite_sequence 4 CREATE TABLE sqlite_sequence(name,seq)
table Buecher Buecher 5 CREATE TABLE Buecher (BuchID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE, Titel VARCHAR(100) NOT NULL, AutorID INTEGER, ISBN VARCHAR(20))
table Log Log 9 CREATE TABLE Log (LogID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE, Datum VARCHAR(20) NOT NULL, Info VARCHAR(255) NOT NULL)

29.03.2013 10:05:30

ropSQLiteIt v1.1 (Build: 20130329), Copyright (c) 2013 Robert W.B. Linn, Pinneberg, Germany.