I may have gone through the BOL thousands of times looking for various xtypes. But this time had a closer look at xtype = 'L' Object type. Can be one of these object types: C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L = Log FN = Scalar function IF = Inlined table-function P = Stored procedure PK = PRIMARY KEY constraint (type is K) RF = Replication filter stored procedure S = System table TF = Table function TR = Trigger U = User table UQ = UNIQUE constraint (type is K) V = View X = Extended stored procedure What is xtype = 'L'. Just don't have any idea what is this? I hv never seen this. Does anybody here know this?