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'