SQL query for column name

Question

0.00/5 (No votes)

See more:

Hi,

IF i dont know the column name of a table but some part of the name i know, then how to search a column name in sql database.

Regards,
Rahul Agarwal

Posted 16-Aug-13 23:19pm

Member 10214939

Add a Solution

3 solutions

Solution 1

You can use INFORMATION_SCHEMA, see here : http://en.wikipedia.org/wiki/Information_Schema[^]

Posted 16-Aug-13 23:21pm

Mehdi Gholam

Solution 2

How to search a column name within all tables of a database and how to search stored procedures containing a particular text[^]

sql-server-query-to-find-column-from-all-tables-of-database/[^]

t-sql-find-column-name-in-database-in-any-table-using-sql-server-tsql-system-query[^]

Check the links..these are some ways you can go for depending on your situation.

Posted 16-Aug-13 23:47pm

Code-Hunt

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sadique KT · Accepted Answer · 2013-08-16T23:50:00

Solution 3

SQL

SELECT COLUMN_NAME, TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%name%'

use the same query and replace name in '%name%' with your searching keyword.

Posted 16-Aug-13 23:50pm

Sadique KT

Updated 16-Aug-13 23:52pm

v2