Hello Experts !!
I created a custom table in AF using System Explorer but wanted to know if this table could be accessed in the PIFD database using.
From the User Guide if it helps:
PI AF saved library
The PI AF saved library provides a collection of application or domain specific objects that you
can import into a PI AF database. Saved libraries typically include categories, element
templates, enumeration sets, reference types, tables, and the unit-of-measure Database.
However, when you save a library, you have the option to include other objects, such as
elements and notifications. While the UOM Database is not shown within the Library tab in the
Navigator Pane, it is always included as part of saved libraries.
Libraries are stored as XML within the AF SQL Database. This is very different from the
Export to File option, which exports an entire database as an XML file.
Thanks for your reply, that led me to searching for a few tables and found that in the PI AF database there is a table called 'AFTable' which includes reference to custom tables added on AF, and the values are present in xml format in table 'AFTableVersion'.
If you want to access the Data of the AF Table (Library->Tables) with MS-SQL e.g. Stored Procedures... you can find the informations in the SQL-Table dbo.AFTableVersion. In the row datatable you find the DataSet (xml encoded like Karl did already mention).
e.g. i did configure a Table "Proben1":
in SQL Management Studio it looks like this:
Retrieving data ...