in reply to if table exists (DBI)
List names of all tables and views After the connection to Oracle or Sybase or MySQL has been established, the names of all tables and views that belong to the user are displayed. User can then select one by clicking it (single selection). The list of tables and views is retrieved by using the following queries: (1) Oracle: select table_name from user_tables; select view_name from user_views; (2) Sybase: select sysobjects.name from sysusers, sysobjects where sysobjects.uid=sysusers.uid and (sysobjects.type='U' or sysobjects.type='V') and sysusers.name='XXX'; (3) MySQL: show tables; Note that MySQL does not support views.
|
---|