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  

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] 



Finding which tables have a field name _efrazier29 Apr