Click here to Skip to main content
15,896,111 members

A generic question about database table

Source: CodeProject     Posted by Kent Sharkey    Wednesday, January 25, 2023 6:00pm    
Take it out for a coffee, have a nice conversation...

I have a big table in a database, what is the best way to get understanding of this table quickly?



Back to all news items

 
GeneralYou need to phrase the question better Pin
bantling26-Jan-23 2:51
bantling26-Jan-23 2:51 
What exactly is "big" about the table?

Does it have lots of columns, lots of rows, lots of references to other tables, lost of references to it from other tables?

You don't even say what type of database it is - SQL, NoSQL, etc.

If it is SQL, there will be tables you can query to get info about all the references to it, tables it references, and other details. If there is a provided CLI querying tool, it may have special commands that make these queries much easier. There is almost certainly a graphical tool that can provide these details with a relatively simple click process.

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.