sp_help includes information about deferred tables in the object_status column. This example shows a partial sp_help output for the im_not_here_yet deferred table:
sp_help im_not_here_yet
Name Owner Object_type Object_status Create_date --------------- ----- ----------- ------------------- ------------------- im_not_here_yet dbo user table deferred allocation Apr 9 2012 2:09PM
sysobjects includes the 0x80 status bit in the sysstat3 column to indicate that a table is deferred.
