What are tables has specified column in a database?



SELECT tab.name AS Table_Name,
SCHEMA_NAME(schema_id) AS SCHEMA_NAME,
coltab.name AS COLUMN_NAME,tab.CREATE_DATE,tab.MODIFY_DATE
FROM sys.tables AS tab
INNER JOIN sys.columns coltab ON tab.OBJECT_ID = coltab.OBJECT_ID
WHERE coltab.name LIKE '%name%' -- give column name which one you want to know
ORDER BY schema_name, table_name;


Additionally want to know this:
Diffault access modifiers in C#