Can I set table and field level comments

[mdav2]

Hi,

Is it possible to add field comments and table comments to tables in SQL Server? This effectively makes the database its own data dictionary. I know this can be done in Oracle but I am not sure if SQL Server effers the same

Thanks,

Mark

Mark Davies
Warwickshire County Council

 

[Jamfool]

sp_addextendedproperty (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms180047.aspx

or you can add use the giu to achieve the same.