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?
Code:
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