| 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 _ | efrazier | 29 Apr |
