Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA TABLES WHERE TABLE_NAME = TestTable

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