DatabaseLink lets you connect to and use databases. Here, SQLTableInformation is used to get meta-information about SQL tables.
First create the example database:
Wolfram Language code: Needs["DatabaseLink`DatabaseExamples`"];Wolfram Language code: DatabaseExamplesBuild[ ]
After loading DatabaseLink and opening a connection to a database, get information about the tables:
Wolfram Language code: Needs["DatabaseLink`"];Wolfram Language code: conn = OpenSQLConnection["publisher"];Wolfram Language code: SQLTableInformation[conn]//TableForm
View the same information with column headings:
Wolfram Language code: SQLTableInformation[conn, "ShowColumnHeadings" -> True]//TableForm