SQL 2000 create table model

[A@Rome]

Hi all, in the Create Table basic template of the SQL Query Analyzer, can someone explain me what does it means the " N " near the table name in the condition to establish if the table must be dropped?

IF EXISTS(SELECT name 
	  FROM 	 sysobjects 
	  WHERE  name = N' table_name, sysname, test_table>' 
	  AND 	 type = 'U')
    DROP TABLE <table_name, sysname, test_table>
GO

CREATE TABLE <table_name, sysname, test_table> (
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL, 
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
GO

Thank you

[MAK]

It simply mean use Nvarchar/Nchar.

example


select datalength(N'All')
select datalength('All')

[A@Rome]

thank you very much