He wants an ER diagram, not a dump of the tables and contents. I wanted this too and did some digging.
There are a lot of pay tools that can do this (I think navicat for example does it). If pay tools are not an option, there are a bunch of things that claim to work, such as SQLFairy and some various JAVA libraries but never got updated to support foreign keys in sqlite. The best free option I've found is adminer, though it doesn't do automatic layout and doesn't seem to have print capability. If you don't need to generate diagrams all the time, you could manually arrange the contents until you're happy and then take a screen shot. That said, having looked at tens of free options and seen the average quality, I would strongly recommend paying a few hundred bucks for a professional product if I needed this functionality. -sean -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Donald Griggs Sent: Tuesday, December 06, 2011 5:21 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diagram Regarding: > > Hello i want to know how to get the database diagram from sqlite.Please > tell > me the solution.Thanks in Advance. > > Quick answer: The sqlite3 utility, linked from the sqlite.org website, can dump schema with the .schema command. If you need more than this, you will have to look to utility programs written by others. More detailed answer: Priya, if the quick answer above makes no sense to you, then I suggest you write back to this list using many more words. This list is for those incorporating sqlite into their computer programs. If you're not doing programming, let us know what application you're using, what type of database diagram you're wanting, and perhaps what the eventual goal is -- then someone here might (or might not) be able to direct you better. Donald _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ----------------------------------------------------------------------------------- This email message is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ----------------------------------------------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
