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.
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:
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.