By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,686 Members | 1,603 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,686 IT Pros & Developers. It's quick & easy.

what does [dbo].[Accounts] mean?

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
> 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

Jul 23 '05 #2

P: n/a
You can also have {DB].[dbo].[accounts] where DB is the database name

Madhivanan

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.