Linked Questions

Ask Question
39 questions linked to/from How can I find all the tables in MySQL with specific column names in them?
Hot Newest Score Active Unanswered
37 votes
3 answers
44k views

I'm trying to find if my database has a column named sort_method. I have had a look around the forums, but I don't seem to be able to find the right answer. My database has over 300 tables, so ...
Ledgemonkey's user avatar
  • 7,511
18 votes
2 answers
41k views

I am running a huge database with so many tables and tables are having so many columns. My DB is MySQL and I have to search for a particular column. Is there a way available in MySQL to search a ...
Joomler's user avatar
  • 2,818
-1 votes
1 answer
11k views

Possible Duplicate: How to find all the tables in MySQL with specific column names in them? I want to select tables from sql where the table has a column named "TimeStamp". How do I list all the ...
John's user avatar
  • 838
2 votes
1 answer
17k views

I am working on a huge database. I want to find all the tables in all the database which contains columns name say "xyz" (cann't say actual column name). Is there any query or other way to solve the ...
Puneet Purohit's user avatar
  • 1,291
1076 votes
24 answers
3.4m views

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?
odiseh's user avatar
  • 26.7k
227 votes
28 answers
954k views

I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named EVENT_LOG that contains eventID, eventType, eventDesc, and ...
Paxenos's user avatar
  • 2,886
20 votes
4 answers
28k views

Is there a way to search the database if a column name / field name exists in a table in mysql?
rjmcb's user avatar
  • 3,745
19 votes
3 answers
46k views

I am trying to alter multiple tables and change the size of the username VARCHAR column to 999 as its current size is too small and now things are screwed up. How can I do this? I have tried the ...
John Doe's user avatar
  • 3,682
5 votes
2 answers
44k views

I have 2-3 different column names that I want to look up in the entire DB and list out all tables which have those columns. Any easy query? I have seen solution for MySQL, which won't work here ...
Rocketq's user avatar
  • 5,841
1 vote
6 answers
12k views

Can I write an sql query that can find the names of all tables in a database that have column name like %COL_FAX_ID%. If so, how? Database used is oracle or db2.
Vamsi Emani's user avatar
  • 10.4k
2 votes
2 answers
12k views

I already have read some answers on this. But all of them are giving me the same error. Here are the solutions I read: Link 1 Link 2 import sqlite3 as sql #connect to database connection = sql....
Adarsh Maurya's user avatar
  • 358
5 votes
2 answers
4k views

I want to get all table names which has 3 specific columns. What I want is from information schema I want to get all table names which contains columnA AND columnB AND columnC. Currently I am using ...
Nis's user avatar
  • 1,477
4 votes
3 answers
2k views

I have a database named bbs, which have 37 tables. I want to find all columns in these tables where the column name length is greater than 5! mysql> show tables; +---------------------+ | ...
Neo's user avatar
  • 5,513
2 votes
1 answer
1k views

I am doing a mySQL 'SHOW TABLES' with a 'LIKE'. For example: show TABLES like 'address_%' ... to return all tables that start with 'address_'. That works fine. The table name that is returned has a ...
Graham's user avatar
  • 129
-1 votes
1 answer
2k views

I'm using Workbench, I'm not an expert at SQL but always open to learning. My goal is to Update multiple tables at once and have the Replace happen on all found results. Something like: SELECT * ...
user10129980's user avatar
  • 13

15 30 50 per page
1
2 3