Create Procedure dbo.sp_SelectTableColumns
	(
	@Schema varchar(255),
	@TableName varchar(255),
	@IncludePrimaryKeyColumns bit = 1,
	@IncludeNonPrimaryKeyColumns bit = 1
	)
As

SELECT 
	ColumnName = C.COLUMN_NAME,
	IsPrimaryKeyColumn = IsNull(KEYS.IsPrimaryKeyColumn, 0),
	ColumnDescription = Convert(nvarchar(4000), SP.value)
FROM INFORMATION_SCHEMA.COLUMNS C
	LEFT OUTER JOIN sysobjects SO
		ON C.TABLE_SCHEMA = user_name(SO.uid)
		AND C.TABLE_NAME = SO.name
	LEFT OUTER JOIN sysproperties SP
		ON SO.id = SP.id
		AND C.ORDINAL_POSITION = SP.smallid
		AND SP.type = 4
		AND SP.name = 'MS_Description'
	LEFT OUTER JOIN (
		SELECT KCU.COLUMN_NAME, IsPrimaryKeyColumn = 1
		FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
		INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU
  			ON TC.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME
		WHERE TC.TABLE_SCHEMA = @Schema
			AND TC.TABLE_NAME = @TableName
			AND TC.CONSTRAINT_TYPE = 'PRIMARY KEY'
	) KEYS
		ON C.COLUMN_NAME = KEYS.COLUMN_NAME
WHERE
	C.TABLE_SCHEMA = @Schema
	AND C.TABLE_NAME = @TableName
	AND IsNull(KEYS.IsPrimaryKeyColumn, 0) = CASE 
		WHEN @IncludePrimaryKeyColumns = 1 AND @IncludeNonPrimaryKeyColumns = 1 THEN IsNull(KEYS.IsPrimaryKeyColumn, 0)
		ELSE @IncludePrimaryKeyColumns
	END

CREATE TABLE dbo.tblJunk
	(
	JunkKey int NOT NULL IDENTITY (1, 1),
	Junk varchar(50) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.tblJunk ADD CONSTRAINT
	PK_tblJunk PRIMARY KEY CLUSTERED 
	(
	JunkKey
	) ON [PRIMARY]
GO
DECLARE @v sql_variant 
SET @v = N'This is the PK.'
EXECUTE sp_updateextendedproperty N'MS_Description', @v, N'user', N'dbo', N'table', N'tblJunk', N'column', N'JunkKey'
GO
DECLARE @v sql_variant 
SET @v = N'This is not the PK.'
EXECUTE sp_updateextendedproperty N'MS_Description', @v, N'user', N'dbo', N'table', N'tblJunk', N'column', N'Junk'
GO