topic Database table for categories - Reg in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-table-for-categories-reg/m-p/216407#M169537 <HTML><HEAD></HEAD><BODY><SPAN>Hi Team,</SPAN><BR /><BR /><SPAN>I have seen the list of tables(starts with "ALF_") in Oracle database pertaining to the Alfresco CMS.</SPAN><BR /><BR /><SPAN>Could anyone please tell me which table is corresponding to the categories in Alfresco?</SPAN><BR /><BR /><SPAN>If not, where the categories are being stored when I tried to add it via category management in the admin gui?</SPAN><BR /><BR /><SPAN>Thanks and Regards,</SPAN><BR /><SPAN>Ganesh Kumar.</SPAN></BODY></HTML> Wed, 01 Sep 2010 13:25:15 GMT ganmaku 2010-09-01T13:25:15Z Database table for categories - Reg https://connect.hyland.com/t5/alfresco-archive/database-table-for-categories-reg/m-p/216407#M169537 Hi Team,I have seen the list of tables(starts with "ALF_") in Oracle database pertaining to the Alfresco CMS.Could anyone please tell me which table is corresponding to the categories in Alfresco?If not, where the categories are being stored when I tried to add it via category management in the admi Wed, 01 Sep 2010 13:25:15 GMT https://connect.hyland.com/t5/alfresco-archive/database-table-for-categories-reg/m-p/216407#M169537 ganmaku 2010-09-01T13:25:15Z Re: Database table for categories - Reg https://connect.hyland.com/t5/alfresco-archive/database-table-for-categories-reg/m-p/216408#M169538 <HTML><HEAD></HEAD><BODY><SPAN>FWIW, Categories are just special nodes of type cm:category located under /categoryRoot/generalclassifiable/…, just use the node browser to dig in.</SPAN><BR /><BR /><SPAN>Which in turn means, that all your usual knowledge of Alfrescos database schema applies, which is perhaps not what you wanted to hear <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><BR /><SPAN>Seriously, in 9 out of 10 cases it is just a bad idea to access Alfresco's database directly, usually there is a well-known service for what you want. Maybe if you tell us what you want to achieve we can provide a better hint&nbsp; :mrgreen: </SPAN><BR /><BR /><SPAN>Cheers</SPAN><BR /><SPAN>Gyro</SPAN></BODY></HTML> Wed, 01 Sep 2010 14:14:34 GMT https://connect.hyland.com/t5/alfresco-archive/database-table-for-categories-reg/m-p/216408#M169538 gyro_gearless 2010-09-01T14:14:34Z