SQL: Find All Tables with a Specific Column

[@pravinprince3221]

Thank you for the wonderful video sir, it is so helpful for me and my team , thanks again sir

[@DatabaseStar]

Glad it helped!

[@minnuss]

Great Tip! Thank you !

[@DatabaseStar]

You're welcome

[@matrixevo88]

Great video! Is there a simple way to include a count of rows for each column_name? I mostly use SQL Server.

[@DatabaseStar]

Thanks! What do you mean by "count of rows for each column name"? Each column will have the same number of rows - the rows are part of the table. For example, a customer table with 5 rows would have 5 rows for first name and 5 rows for last name.

[@matrixevo88]

@@DatabaseStar I didn't word that well. By "count of rows for each column name" I am referring to the same value that would be returned using SELECT COUNT(*) FROM ;. So technically it would be a count of rows for each table. I don't think it's a value existing in the data dictionary (e.g., information_schema). It's probably not a feasible query. It would just be neat to have that extra piece of information (like metadata) for each table. I suppose that's out of scope for this video anyway, because it's about columns more than tables.