SQL SERVER - OBJECT_ID AND type (N) purpose

Asked Jun 04 '15 at 11:22

Active Jun 04 '15 at 11:22

Viewed 39 times

I had a question regarding OBJECT_ID and using it with DROP and CREATE tables.

WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') AND type in (N'U'))

What does the "N" in the above code do? I understand that 'U' is a user-defined table. I tried looking the meaning of 'N' however I cannot find a sastifying reason.

Two examples:

Does the 'N' do anything specific when checking the existance of a user-defined table for the purpose of dropping or creating a table?

asked Jun 04 '15 at 11:22

user3197575

4

National character literal. (Unicode.) – jarlh Jun 04 '15 at 11:23
What function does it have? Would it absence affect the operation with the argument 'U' (User-defined)? – user3197575 Jun 04 '15 at 11:27
It's just an indication that the following literal may contain Unicode characters. N'U' is equal to 'U' value wise, but different data types. – jarlh Jun 04 '15 at 11:29

SQL SERVER - OBJECT_ID AND type (N) purpose

0 Answers0