Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1164

'show tables' and 'describe' commands in ij

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 10.2.1.6
    • Tools
    • None
    • Urgent

    Description

      New users migrating from mysql are familiar with commands 'show tables' and 'describe' to respectively display all permanent tables, and show fields in a given table. These are not standard sql, but I suggest to implement them only in the IJ tool for user-friendliness.

      As suggested in db-dev, using DatabaseMetaData should provide the necessary query strings.

      Attachments

        1. 1164.diff
          5 kB
          Håvard Mork
        2. 1164_5_andrew.diff
          55 kB
          Samuel Andrew McIntyre
        3. 1164_4.diff
          50 kB
          Håvard Mork
        4. 1164_3.diff
          45 kB
          Håvard Mork
        5. 1164_2.diff
          20 kB
          Håvard Mork

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-457 Support for equivalent of Oracle's describe command

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              hmork Håvard Mork
              hmork Håvard Mork
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: