Export Table / View Describes (Like SQL Describe)

Description

Can export the contents of the view or table into excel.
BUT! How do we export the describe of the table configuration (Column Name, Column Type, Length, FK, PK, etc. — like a SQL table describe?)

See Attachment. Not sure if Bug or Enhancement ...or it is there and have nto found it.

Environment

ConfluenceCloud

Observations

None

Activity

Show:
Tina Huston
May 28, 2019, 12:49 PM

Good am Adrien! Best support ever. Thank you so much.

Ok - trying to use the plugin primarily for documentation for two types of projects: 1) development, 2) deployment of solutions where data migration is required.

In case 1 - want to use for both defining the schema, documenting the schema and preparing sample data for testing. Like an analyst would do. In the same way that you can export the tables with data — would like to export (and be able to display the describe on a confluence page) the table or view describes. So — really asking for

1) option to ‘display’ either table or view in describe mode (not just data mode)
2) export either single tables or views or ‘all’ in described mode
3) from #2 - use visio or another program to draw and erd to display in the spec document (again in perfect world — could you’d the plugin to display the erd on a page or export in a format that could draw an erd)

Thx for listening!

Tina

Adrien Ragot (Play SQL / Requirement Yogi)
May 28, 2019, 8:06 AM
Edited

Hi Tina,

What will you do with it? I’m asking this because currently this information is fully available in the SQL export, but it seems it’s not in the format you want. Concerning the column types for example, either you need to import to another engine and you need them, either you want to massage the data with Excel and Excel is lenient about column types. In any case, concerning other data such as foreign keys, I don’t see where they would be used other than in an SQL database, and any other format of export would “lose” some information compared to the complete SQL export.

Do you want this format you request to be read by a human, or to import it in another program?

Thank you,

Adrien

Tina Huston
May 27, 2019, 10:51 PM
Edited

This does not fully meet the need. Looking for a way to get out the "definition" of each table, view — or the total. Not export the SQL DB. Not sure if this an enhacement reuqest?

Adrien Ragot (Play SQL / Requirement Yogi)
May 27, 2019, 7:07 PM

Hi,

The best way is to export the SQL. Go to the app administration, click "Manage backups" and click on a backup to download it. You will get the SQL version.

Best regards,
Adrien

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Tina Huston

Participants

None

Priority

Matter of days