Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

How to search for a column name?

serhio's profile image serhio posted 2 weeks ago in General Permalink


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 2 weeks 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.