>In the enterprise manager you can assign a description to tables under the properties. Is it possible to query tables without a description assigned? Is is possible to modify the description value from within an application?

Hi Kirk,

See fn_listextendedproperty function and sp_addextendedproperty in BOL.

-- Get list of tables w/o descriptions in pubs DB
SELECT * FROM pubs.INFORMATION_SCHEMA.TABLES
	WHERE table_name NOT IN (
		SELECT  objname
			FROM   ::fn_listextendedproperty ('MS_Description', 
	'user', 'dbo', 'table', Null, Null, Null))
-- Add description to Authors table in pubs DB
sp_addextendedproperty 'MS_Description', 
  'This is Authors table - Description', 
  'user', 'dbo', 'table', 'authors'