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

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

Let's assume that you have a database named contact_mgr that contains a database table named Salespeople. To show the structure of the Salespeople table, just type this command at the Unix command line:

Our sample Salespeople table contains just a few columns, and the output from relshow looks like this:

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: