List:General Discussion« Previous MessageNext Message »
From:efrazier Date:April 28 1999 9:43pm
Subject:Finding which tables have a field name _
View as plain text  
Hi,

How would I go about finding out which tables in a database have a certain
field named "acct"? I was wondering if there might be some extention to the
'show tables' command that would make it easy to find out, without having to
do something with code.  

.....

Ok I did read the manual and ansered my own question :) 

SHOW [COLUMNS|FIELDS] FROM table [FROM database] [LIKE wild] 



Thanks,

Eric 

Thread
Finding which tables have a field name _efrazier29 Apr