Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Find A Columns Name

Home
Forums

Find A Columns Name

Shubham Singh

11yAsked Oct 5, 2015, 1:54 AM929

Hi,

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Jitendra Kumar11y ago
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;

0
Rajeesh Menoth11y ago
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
0
Shubham Singh11y ago
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
0

Jitendra Kumar

Jitendra Kumar11y ago

Try this :-

select table_name,column_name from information_schema.columns where column_name like '%val%'

0

Rajeesh Menoth11y ago
Hi,

Please ref the below link..

http://www.codeproject.com/Tips/136463/How-to-search-a-column-name-within-all-tables-of-a
0