Database Toolbox™

columns - Returns database table column names

Syntax

l = columns(dbmeta, 'cata')
l = columns(dbmeta, 'cata', 'sch')
l = columns(dbmeta, 'cata', 'sch', 'tab')

Description

• l = columns(dbmeta, 'cata') returns a list of:

  • All column names in the catalog cata

  • For the database whose database metadata object is dbmeta

• l = columns(dbmeta, 'cata', 'sch') returns a list of:

  • All column names in the schema sch

  • In the catalog cata

  • For the database whose database metadata object is dbmeta

• l = columns(dbmeta, 'cata', 'sch', 'tab') returns a list of columns for:

  • The table tab

  • In the schema sch

  • In the catalog cata

  • For the database whose database metadata object is dbmeta

Examples

1. Run columns, passing it the following arguments:

   • The database metadata object dbmeta

   • The catalog orcl

   • The schema schSCOTT

   l = columns(dbmeta,'orcl', 'SCOTT')
   l = 
       'BONUS'       {1x4 cell}
       'DEPT'        {1x3 cell}
       'EMP'         {1x8 cell}
       'SALGRADE'    {1x3 cell}
       'TRIAL'       {1x3 cell}
   

   The results show the names of the five tables in dbmeta, and cell arrays containing the column names in each table.

2. View the column names for the BONUS table:

   l{1,2}
   ans = 
       'ENAME'    'JOB'    'SAL'    'COMM'
   

See Also

attr, bestrowid, cols, columnnames, columnprivileges, dmd, get, versioncolumns

columnprivileges

commit