How to obtain the table name you are looking for on MySql database?

Document ID : KB000013927
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to obtain the table name you are looking for on MySql database?

Answer:

You can obtain the table name you are looking for from netqosportal database on CAPC through the procedure below. Here we are looking for a list of tables that may contain device related information.

1. As a root user on CAPC, go to /opt/CA/MySql/bin

2. ./mysql

3. use netqosportal;

4. mysql> show tables like '%device%';

+-----------------------------------+

| Tables_in_netqosportal (%device%) |

+-----------------------------------+

| dst_device                        |

| dst_device_life_cycle_state       |

| rule_devicetoapplication          |

| t_device                          |

+-----------------------------------+

4 rows in set (0.00 sec)

As you can see, there are four tables returned.