Search code examples
sqldatabasesqliteinformation-schema

Creating DB Schema from sqlite in sqlite manager

I have a sqlite database in sqlite manager. I would like to create DB schema. How can i do that? Or is it best to use some software to create the DB Schema?

Need some suggestions and guidance.

Solution

  • there is a system table called sqlite_master. It contains the SQL CREATE statements for all objects.

    So, all you need to do is to select all rows from this table, and run the sql statements.

    You can also use Database->Export Database Structure, which will effectiveley do the same thing