Can a SQL Output be Made for List of Tables & Fields?

Dell / Mxg071
December 20, 2013 at 13:40:26
Specs: Windows 2000 Server, x
Is it possible, in SQL (and my knowledge of it is quite basic) to get a readout of all tables and the fields in each table? That way, I can copy it all to a spreadsheet and do a manual visualization of fields that match the same name in other tables.

I am doing this on a program called ElevateDB.

Thank you.

I reply as fast as I can, but it could be hours or months. Always busy.


See More: Can a SQL Output be Made for List of Tables & Fields?

Report •


#1
December 21, 2013 at 12:21:51
In all commercial databases, the schema of the database is stored in system tables (sometimes called a catalog) within the database. Obviously, each database catalog is different. Check out the ElevateDB system information:

http://www.elevatesoft.com/manual?a...


Report •

#2
December 24, 2013 at 08:10:28
I am sorry but I tried a bunch of those, and still without fully understanding SQL, they keep giving me errors. It would be more helpful to show me the actual code so I can try it. If it works, then I can learn from that code.
Thank you.

I reply as fast as I can, but it could be hours or months. Always busy.


Report •

Related Solutions


Ask Question