|
Home > Archive > Microsoft SQL Server forum > April 2005 > what does [dbo].[Accounts] mean?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
what does [dbo].[Accounts] mean?
|
|
| Steve Richter 2005-04-24, 8:23 pm |
| 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 2005-04-25, 3:23 am |
| > 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
>
| |
| Madhivanan 2005-04-25, 7:23 am |
| You can also have {DB].[dbo].[accounts] where DB is the database name
Madhivanan
|
|
|
|
|