What does 'N' means in this transact-SQL statement?


I got these statements in an example of SELECT in MS SQL:

if exists (SELECT * from dbo.sysobjects WHERE id = object_id(N'dbo.employee') and OBJECTPROPERTY(id, N'IsUserTable')=1)
drop table dbo.employee

There exists an 'N' inside the above statement, I tried to figure out what it is, but I couldn't.

If you know, please help. Thanks


Who is Participating?
Anthony PerkinsCommented:
It inidicates the character string is unicode (supports double byte character languages).
Anthony PerkinsCommented:
Take a look at the definition of OBJECT_ID:

Returns the database object identification number.

OBJECT_ID ( 'object' )


Is the object to be used. object is either char or nchar. If object is char, it is implicitly converted to nchar.

Notice how it supports the nchar data type.  nchar is a unicode datatype.
Anthony PerkinsCommented:
Also, as friendly reminder please maintain your many abandoned questions.  Here are listed all your open questions:

1 02/27/2005 250 Why Red Hat Linux Pro 9.0 no loner recog...  Open Linux Setup
2 03/18/2005 250 I want to download all the microsoft upd...  Open Windows 2000
3 03/22/2005 500 Lost in a maze of Cisco flexibility  Open Networking
4 04/04/2005 500 Approximate power budget for satellite c...  Open Networking
5 04/27/2005 125 Text marked with "Do not check spelling ...  Open Microsoft Word
6 04/30/2005 250 How to create a script to change content...  Open Microsoft SQL Server
7 05/01/2005 250 What does 'N' means in this transact-SQL...  Open Microsoft SQL Server
8 06/22/2004 250 How to define CONFIG_CRYPTO_HMAC inkerne...  Open Linux Setup
9 08/06/2004 250 How to make nslookup works without dns s...  Open Linux Setup

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.