how do I get the table name from a query?

Поиск
Список
Период
Сортировка
Искать

how do I get the table name from a query?

От:
"Reggie Burnett" <rykr@bellsouth.net>
Дата:

When using the FE/BE, how do I retrieve the table name for a given column?  Say I had the following SQL:

 

Select c.id, c.name, d.phone from Members c, Addresses d where c.id < 200

 

From the docs of the FE/BE, I would see that the fields are named id, name, phone but how do I find out the source tables that each field came from?  I need to know this to discover nullability of fields, uniqueness, etc.

 

Thanks

Reggie

Re: how do I get the table name from a query?

От:
"Reggie Burnett" <rykr@bellsouth.net>
Дата:

Re: how do I get the table name from a query?

От:
Dave Cramer <dave@fastcrypt.com>
Дата:
FAQ