How to find the database name using the table name?

Question

I found the table name exist in my system, I used the following query;

select * from sys.tables where name = '%openpotab%';

But how can I find the database name using the table name?

thanks in advance, Bhavesh

Lukasz Szozda · Accepted Answer · 2018-07-11 14:55:20Z

1

You could use:

select DB_NAME(DB_ID()), * from sys.tables where name LIKE '%openpotab%';

answered Jul 11, 2018 at 14:51

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

The first column is blank in the result set. It means there is no database name?

@Bob Please check now