CodeIgniter Library for Accessing MSSQL Extended Property

extended_property.php

<?php

class Extended_property {

   var $CI;

   function Extended_property()
   {
      this->CI =& get_instance();
   }

   function get($table, $column, $property)
   {
      $result = $this->CI->db
           ->query('
                SELECT value
                FROM ::fn_listextendedproperty(
                     N\''.$property.'\',
                     N\'user\', N\'dbo\',
                     N\'table\', N\''.$table.'\',
                     N\'column\', N\''.$column.'\')')
           ->limit(1)
           ->row();

      return (!empty(@$result->value)) ? $result->value : false;
   }

   function set($table, $column, $property, $value)
   {
      $this->CI->db
           ->query('
                IF EXISTS(
                     SELECT value
                     FROM ::fn_listextendedproperty(
                          N\''.$property.'\',
                          N\'user\', N\'dbo\',
                          N\'table\', N\''.$table.'\',
                          N\'column\', N\''.$column.'\'))
                EXEC sp_dropextendedproperty
                     N\''.$property.'\',
                     N\'user\', N\'dbo\',
                     N\'table\', N\''.$table.'\',
                     N\'column\', N\''.$column.'\';
                EXEC sp_addextendedproperty
                     N\''.$property.'\', N\''.$value.'\',
                     N\'user\', N\'dbo\',
                     N\'table\', N\''.$table.'\',
                     N\'column\', N\''.$column.'\'');
   }

}