 |
DATABASELINK SYMBOL
SQLColumnNames
SQLColumnNames[conn]
returns a list of 
pairs for each column in an SQL connection.
Examplesopen all
Basic Examples (1)
| In[1]:= |
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the 
package, as described in Using the Example Databases.
| In[2]:= |
| In[3]:= |
Out[3]//Short= | |
 | |
Get 
pairs from tables whose names start with "SA":
| In[4]:= |
| Out[4]= |  |
Get 
pairs from a particular table:
| In[5]:= |
| Out[5]= |  |
| In[6]:= |
| In[7]:= |
| Out[7]= |  |
Get 
pairs for columns whose names begin with "V" in any table:
| In[8]:= |
| Out[8]= |  |
| In[9]:= |
| Out[9]= |  |
Extract just the column names:
| In[10]:= |
| Out[10]= |  |
| In[11]:= |
