what does [dbo].[Accounts] mean?

[Steve Richter]

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

[Dan Guzman]

> 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" <St************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.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

[Madhivanan]

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

Madhivanan