I want to know the column called as BSEID exist in which all table and in which schema . please help us

Hope this will help

SELECT c.[name] AS ColumnName, SCHEMA_NAME([schema_id]) AS SchemaName, OBJECT_NAME([o].[object_id]) AS TableName
FROM sys.[columns] AS C
INNER JOIN sys.[objects] AS O ON [C].[object_id] = [O].[object_id]
WHERE ([type] = 'U' 
      --OR [type] = 'S' --UNCOMMENT IF WANTED TO SEE SYSTEM TABLES AS WELL
      )
      AND c.[name] = 'BSEID'