find column name in db

Question

Hey,

how to find a data in the database for an example . I want to find out mobile number column from all tables in database

Answer 1

I typically run queries like:

SELECT s.name, t.name, c.name
FROM   sys.columns c
JOIN   sys.tables t ON c.object_id = t.object_id
JOIN   sys.schemas s ON t.schema_id = s.schema_id
WHERE  c.name LIKE '%mob%'

Of course this assumes that the column naming is "reasonable". For a larger database with many tables, this can be a bit of needle-in-a-haystack thing.

Note: because you can add up to five tags in a post, doesn't mean that you have to. I took the liberty to remove two tags that were entirely irrelevant.

Answer 2

Hi @Vineet S

Try this:

SELECT * 
FROM information_schema.columns 
WHERE column_name = '

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.