Find column name in database

--Option #1
-------------------------------------

SELECT name, column_id, * 

FROM sys.columns 
WHERE object_ID = (
                SELECT a.object_id --b.name as 'schema_name'

                        , a.name

                        , a.object_id

                        , a.schema_id

                        , a.parent_object_id

                        , a.type

                        , a.type_desc

                        , a.create_date

                        , a.modify_date

                    FROM sys.objects a INNER JOIN sys.schemas b 

                        ON a.schema_id = b.schema_id

                    WHERE object_id IN (

                                        select object_ID 

                                        from sys.columns 

                                        where name like 'snapshot%'

                                        )

                        AND b.name = 'snapshot'

                        AND a.name = 'T2_Flatfile_snapshot_level'

                     --ORDER BY a.[type], b.name, a.name
)

--Option #2
-------------------------------------

select *
from sys.objects
where object_id IN (select object_ID 

                    from sys.columns 

                    where name like '30Day%')

--Option #3
-------------------------------------

SELECT b.name as 'schema_name'

    , a.name

    , a.object_id

    , a.schema_id

    , a.parent_object_id

    , a.type

    , a.type_desc

    , a.create_date

    , a.modify_date

FROM sys.objects a INNER JOIN sys.schemas b 

    ON a.schema_id = b.schema_id
WHERE object_id IN (    select object_ID 

                        from sys.columns 

                        where name like 'snapshot%')
and b.name = 'snapshot'
and a.name = 'T2_Flatfile_snapshot_level'

ORDER BY a.[type], b.name, a.name

--Option #4
-------------------------------------

SELECT b.name as 'schema_name', a.name, a.object_id, a.schema_id

    , a.parent_object_id, a.type, a.type_desc, a.create_date

    , a.modify_date
FROM sys.objects a INNER JOIN sys.schemas b 

    ON a.schema_id = b.schema_id
WHERE object_id IN (select object_ID 

                    from sys.columns 

                    where name like 'snapshot%')
and b.name = 'dbo'
and a.name = 'Flatfile_snapshot'
ORDER BY a.[type], b.name, a.name


SELECT name, column_id FROM sys.columns where object_ID = 109503719
order by 2
union all
SELECT object_id, name, column_id FROM sys.columns where object_ID = 823934257
order by 2