SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TestTable' : Information_schema « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. Information_schema

5> CREATE DATABASE Test
6> GO
1> CREATE TABLE TestTable(
2>    col1   int,
3>    col2   int
4> )
5> GO
1> SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TestTable'
2> GO
TABLE_CATALOG
--------------------------------------------------------------------------------------------------------------------------------
master

(1 rows affected)
1>
2> drop table TestTable;
3> GO
1>
2> drop database Test;
3> GO