Home > Back-end >  To get table name and details using just the column name in mysql database
To get table name and details using just the column name in mysql database

Time:11-11

can anyone help me in getting the table name and details from an SQL database whose column name is just known to me ?

CodePudding user response:

As mentioned in the comments you can get information about your table from the INFORMATION_SCHEMA

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'your-column-name'
  • Related