How to search for a column name?

serhio's profile image serhio posted 5 years ago in General Permalink

Hello,

I need to add to a table a column "year". I wonder if such columns are already present in the database and what it ther type and other settings.

I would like to search my database for all columns containing "Year" is that possible?

ansgar's profile image ansgar posted 5 years ago Permalink

On MariaDB and MySQL, and on some others, you have the information_schema.columns table, which you can browse with HeidiSQL's data tab.

Please login to leave a reply, or register at first.