Adding extended properties to the table on SQL Server? (e.g. Description)

Easy to do:

use gato

DECLARE @v sql_variant

SET @v = N'DES'

EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'TABLE', N'GATO1', N'COLUMN', N'ID'

Results:

Add description to the TABLE GATO1 on ID column. The description is DES