SQL find table by column name

Good morning all,

I have a databse that I need to find a table in. I am using SQLTalk to query the database. I have a column name that exists in this table. I was hoping someone could help me with a command that will give the table name by searching for the column. Any help is appreciated!

 

Is it an enormous DB?

Do you have any idea what table the column would be found in? You could use:
show tables;
to see all tables and then:
describe (each individual table name);
to see all columns. If this isn't too expansive, you can copy all and paste to notepad or word and do a find for your column name.

Hope this was of some help.

 

Yeah dude. Its HUGE. I've tried the method you've described, but for some reason it doesn't like the show tables command. Go figure. It says:

show tables
^
Error: 05034 TLK ISH Invalid show command

This is a SQLBase DB, for the record.