where is my table ?

Hi Experts,

   I tried to create a table as follows but then I couldn't find it in my computer! Does anyone know where the table locate ?
 or I should create a database before I create a table ? how do I do that ? thanks !

C:\MSDERelA>OSQL -E
1> create table employee (firstname varchar(15), lastname varchar(15), title var
char(30), age number(3), salary number(6,2)) ;
LVL 1
meow00Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
AaronAbendConnect With a Mentor Commented:
most likely, your table is in the Master database, since that is where you go by default using the command you showed. If the user was set up with a specific database, you would go there.

If you have a database called Company ("create database company" will do it, though it will be a very small  database which could cause performance problems - best bet is to use Enterprise Manager and try to determine how large the database will get, in MB, and enter that in the database file tab of the create database dialog).

Once you log in, type

use company
go

and now you will be "in" the company database, and the actions you take will create tables in that database and modify data in that database.
0
 
jdlambert1Connect With a Mentor Commented:
Each table doesn't get a separate file, they're all in a file with an extension of .mdf or .ndf. Typically, the files have the name of the database, like if your database is named  "Corp" then the tables (and other things) would be stored in a file called "corp.mdf"
0
 
meow00Author Commented:
so .... after I create a database Company, how do I specify that this table belongs to the Company database ? Thanks !
0
 
jdlambert1Commented:
meow, do you have the SQL Server tools: Enterprise Manager, Query Analyzer, DTS, etc?
0
All Courses

From novice to tech pro — start learning today.