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.
1
-
DBSchema is a tool to be used for thisSrinivas G– Srinivas G2016-06-23 09:05:03 +00:00Commented Jun 23, 2016 at 9:05
Add a comment
|
3 Answers
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
8 Comments
lakshmen
it saves the file with an extension sql. I want to look at it. How do i do that?
cha
is it a joke? Just open it with a notepad
lakshmen
this is not i want... i want a graphical form of the database where it shows the relationships between the tables
cha
OK, we misunderstood you. You want a picture. You can use Visio for that. It draws nice pictures. Just connect to your sqlite database using an ODBC connector and Visio will do its magic
lakshmen
I am using mac.. download visio for mac?
|
there is only one database in SQLite for file.
probably you can create a new file and open that with sqlite manager.
1 Comment
lakshmen
no.. i want to get the schema from the manager itself. is it possible?
certainly you can go to Database menu + create new Database
1 Comment
TheWhiteRabbit
if you are talking about this sqlabs.net/sqlitemanager.php then the option of crating a new database in the startup wizard itself