what does [dbo].[Accounts] mean?

What does the "[dbo]." mean in the following sql script stmts?

use [IBuyAdventure]
GO

if exists (select * from dbo.sysobjects where
id = object_id(N'[dbo].[Accounts]')
and  OBJECTPROPERTY(id,N'
IsUserTable') = 1)
drop table [dbo].[Accounts]
GO

and if you please, what does the "N" in N'IsUserTable' mean?

thanks,

-Steve

> What does the "[dbo]." mean in the following sql script stmts?

'dbo' is the schema (a.k.a object owner).  A schema is essentially a
namespace in a relational DBMS.

> and if you please, what does the "N" in N'IsUserTable' mean?

The 'N' string literal prefix is mnemonic for 'National' and denotes a
Unicode character string.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Steve Richter" < StephenRichter@gmail
.com> wrote in message
news:1114389431.733096.158430@f14g2000cwb.googlegroups.com...
> What does the "[dbo]." mean in the following sql script stmts?
>
> use [IBuyAdventure]
> GO
>
> if exists (select * from dbo.sysobjects where
>  id = object_id(N'[dbo].[Accounts]')
>  and  OBJECTPROPERTY(id,N'
IsUserTable') = 1)
> drop table [dbo].[Accounts]
> GO
>
> and if you please, what does the "N" in N'IsUserTable' mean?
>
> thanks,
>
> -Steve
>

You can also have {DB].[dbo].[accounts] where DB is the database name

Madhivanan