1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Trying to understand sf_CmsControlProperty

Trying to understand sf_CmsControlProperty

6 posts, 0 answered
  1. chris_cf
    chris_cf avatar
    32 posts
    Registered:
    04 Jul 2007
    27 Oct 2008
    Link to this post
    Hi,

    Can anyone give any insight as to what the sf_CmsControlProperty table is used for? It seems to have content in it that I no longer use. Is there a way to clean it up?

    I followed the steps to reduce the size of the database but this table seemed unaffected.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    28 Oct 2008
    Link to this post
    Hi chris_cf,

    Thank you for using our services.

    sf_CmsControlProperty table collects data for the Sitefinity controls properties that have been set.

    Regards,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. chris_cf
    chris_cf avatar
    32 posts
    Registered:
    04 Jul 2007
    28 Oct 2008
    Link to this post
    Thanks.

    Why would data remain in this table is a control is deleted?
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    30 Oct 2008
    Link to this post
    Hi chris_cf,

    We do not recommend making changes to the database. This could corrupt your website. When a control is removed from a page its properties data is also removed from the database.

    I hope this helps.

    Regards,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  5. chris_cf
    chris_cf avatar
    32 posts
    Registered:
    04 Jul 2007
    30 Oct 2008
    Link to this post
    Is there a way to repair a corrupted database?
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    31 Oct 2008
    Link to this post
    Hello chris_cf,

    Usually, a backup should be made frequently and if any problems occurs you could restore it. Also you can google for any kind of Database Repair Tools.

    I hope this helps.

    Kind regards,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Register for webinar
6 posts, 0 answered