LISTING 2: Code That Retrieves Extended Properties
 from the Sysproperties System Table

USE pubs
CREATE table foo2 (c1 int not NULL)
INSERT foo2 values (1)
GO
sp_addextendedproperty 'foo2test','comment on foo2.c1', 'user','dbo','table','foo2','column','c1'
GO
SELECT * FROM ::fn_listextendedproperty('foo2test','user','dbo',
'table','foo2','column','c1')