Under which database tables are coming when they are generated in a query

If I'm creating a table with the help of query command, t开发者_开发问答hen under which database can i find it?

depends on what database was defined in ConnectionString credentials. eg

SERVER=myserv; PROVIDER=SQLOLEDB; DATABASE=mydb; UID=sqluser; PWD=sqlpass;

in this case all queries will be run under database named MYDB you may also change current db with following query:

USE SomeOtherDb