View Single Post
  #2 (permalink)  
Old March 22nd, 2010, 12:31 PM
Paul_Turley Paul_Turley is offline
Wrox Author
Points: 183, Level: 3
Points: 183, Level: 3 Points: 183, Level: 3 Points: 183, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: Vancouver, Washington, USA.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The type column indicates the type of object referenced in the sys.objects table. In the example, U is a user-created table. The object types are documented in Books On Line at http://msdn.microsoft.com/en-us/library/ms190324.aspx

Using the letter N before a string value is a common convention in T-SQL to cast the value to a Unicode compatible data type (such as nChar or nVarChar). You'll typically see this in script generated in SSMS.
__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access
Reply With Quote