asked
I want to know the column called as BSEID exist in which all table and in which schema . please help us
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'
