Do I need to prefix "dbo" to table name when creating a table?

[sjh]

Hi,
Is it necessary to prefix the table name with "dbo" when using the CREATE TABLE command?

create table dbo.MYTABLE
or
create table MYTABLE

Is there a difference? If so, which one do you recommend?

Thanks for your help!
Susie

 

[nigelrivett]

Shouldn't be necessary if you are sa or dbo.
If you are not then it probbably will fail.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.