What is type U in Sysobjects?

What is UID in Sysobjects?

UID refers to the User ID of the owner of the object... In SQL 2005 and SQl 2008, you can find it in sys.sysobjects. field name UID. Sys.sysobjects.

What is N and U in SQL Server?

'U' character stands for itself. The N prefix makes it a one-character UNICODE string. OBJECT_ID procedure expects you to pass one of pre-defined one-character values for the second parameter, which needs to be a UNICODE string. This syntax is used to create literals with characters in other encodings, for example.

What is type D in SQL Server?

D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint. FN = SQL scalar function. FS = Assembly (CLR) scalar-function. FT = Assembly (CLR) table-valued function.

What is DBO Sysobjects?

dbo. sysobjects is a SQL 2000 construct that is only in SQL 2008 for backward-compatibility reasons. sys. objects contains a row for each user-defined, schema-scoped object that is created within a database, so you wouldn't have to filter your query at all.