Re: show tables query

2003-10-13 Thread Victoria Reznichenko
"Robert Morgan" <[EMAIL PROTECTED]> wrote: > > Hi, I'm populating a dropdown with table names so the user can then choose the table > he/she wishes to > edit. However I just want to show the lookup tables. I tried "show tables from DB > where table like 'lkp' ;" > but got an error; I'm just won

show tables query

2003-10-13 Thread Robert Morgan
Hi, I'm populating a dropdown with table names so the user can then choose the table he/she wishes to edit. However I just want to show the lookup tables. I tried "show tables from DB where table like 'lkp' ;" but got an error; I'm just wondering whether it can be done using show tables or whet