Find A Columns Name

Question

Hi, I have to find Columns Name When put values in sql .

Jitendra Kumar · Answer

try this:- declare @value varchar(10); set @value='xyz'; declare @s nvarchar(max); set @s=''; select @s = @s + 'SELECT DISTINCT ''' + SCHEMA_NAME(t.schema_id) + '.' + t.name + ''' as TableName, ''' + c.name + ''' as ColumnName,''' + @value + ''' as Value FROM [' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + '] WHERE [' + c.name + '] = ''' + @value + ''' UNION ALL ' from sys.columns c inner join sys.tables t on t.object_id=c.object_id and c.system_type_id in (35,99,175,231,167,239) AND t.type='U'; SET @s = LEFT(@s,LEN(@s)-LEN('UNION ALL')) + ';'; Print @s exec sp_executesql @s;

Rajeesh Menoth · Answer

Hi, Please check these examples. 1) http://stackoverflow.com/questions/5631822/to-get-column-names-from-table-having-a-particular-value 2) http://dba.stackexchange.com/questions/91961/how-to-get-the-column-name-having-a-particular-value-from-a-sql-server-table

Shubham Singh · Answer

Hi Jitendra Kumar, i have to enter values not columns name . In ur Code when u will be enter column name then display table name and columns name but i Want when i enter value then display columns name

Jitendra Kumar · Answer

Try this :- select table_name,column_name from information_schema.columns where column_name like ' %val%'

Rajeesh Menoth · Answer

Hi, Please ref the below link.. http://www.codeproject.com/Tips/136463/How-to-search-a-column-name-within-all-tables-of-a

Find A Columns Name

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)