How to display the structure of a Mini SQL (mSQL) database
by Developer's Daily

Displaying the structure of a Mini SQL (mSQL) database is very simple. All you have to do is use the relshow command.

Let's assume that you have a database named contact_mgr, and you want to know what database tables are contained in the overall database.  At the Unix command line, type:

relshow contact_mgr
Our database contains three tables named Customer, Salespeople, and Orders, so the output of our command is:

At this point you'll be returned to the Unix command line.


Other locations on the Developer's Daily web site

We invite you to visit other free educational resources on our web site: