Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Any good tool (free) for DB Schema?

Any good tool (free) for DB Schema?

Scheduled Pinned Locked Moved Database
databasejavascriptsqlitecomxml
5 Posts 3 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Sandeep Mewara
    wrote on last edited by
    #1

    Is there any known tool for creating a schema (database diagram) (ER) back from the SQLite DB by itself? (Want to avoid creating DB schema from scratch and I already have the database with me) Think SchemaSky is one of it but that needs a lot of work to setup.

    For your read/comments: Beginner’s Guide to understand Kafka Beginners Quick Start to Learn React.js

    L 1 Reply Last reply
    0
    • S Sandeep Mewara

      Is there any known tool for creating a schema (database diagram) (ER) back from the SQLite DB by itself? (Want to avoid creating DB schema from scratch and I already have the database with me) Think SchemaSky is one of it but that needs a lot of work to setup.

      For your read/comments: Beginner’s Guide to understand Kafka Beginners Quick Start to Learn React.js

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      If you mean just to print the CREATE statements, then you can use the sqlite3 command line program.

      S 1 Reply Last reply
      0
      • L Lost User

        If you mean just to print the CREATE statements, then you can use the sqlite3 command line program.

        S Offline
        S Offline
        Sandeep Mewara
        wrote on last edited by
        #3

        Not the statements. That was easy. I am talking of Database diagram. Sorry for confusion.

        For your read/comments: Beginner’s Guide to understand Kafka Beginners Quick Start to Learn React.js

        J 1 Reply Last reply
        0
        • S Sandeep Mewara

          Not the statements. That was easy. I am talking of Database diagram. Sorry for confusion.

          For your read/comments: Beginner’s Guide to understand Kafka Beginners Quick Start to Learn React.js

          J Offline
          J Offline
          Jorgen Andersson
          wrote on last edited by
          #4

          I have ever only used Oracle Sql developer Data Modeler, which is free a even pretty good, but I think it only supports Oracle, Sql Server and DB2 properly. But take a look here for data modeling tools[^]. And here for database diagram tools[^] for SQLite. I would expect quite some overlap between them. Also, please report back if you find any of them useful. SQLite is quite interesting after all.

          Wrong is evil and must be defeated. - Jeff Ello Never stop dreaming - Freddie Kruger

          S 1 Reply Last reply
          0
          • J Jorgen Andersson

            I have ever only used Oracle Sql developer Data Modeler, which is free a even pretty good, but I think it only supports Oracle, Sql Server and DB2 properly. But take a look here for data modeling tools[^]. And here for database diagram tools[^] for SQLite. I would expect quite some overlap between them. Also, please report back if you find any of them useful. SQLite is quite interesting after all.

            Wrong is evil and must be defeated. - Jeff Ello Never stop dreaming - Freddie Kruger

            S Offline
            S Offline
            Sandeep Mewara
            wrote on last edited by
            #5

            Sure, will have a look and report back in case I find anything interesting. Thanks man! :thumbsup:

            For your read/comments: Beginner’s Guide to understand Kafka Beginners Quick Start to Learn React.js

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups