I am currently creating transpose functions in SQL commander, but when I drop the function and create another with the same name, it still says that the function exists? How would I go about actually deleting these functions?
What version of SQL Commander is this happening with? I haven't come across this behaviour before, and don't have this issue using 2016 R2. If it seems to have trouble cleaning up the transpose function objects, you could always go to the stored definition in the Configuration database in PI AF. Look under the OSIsoft/PI SQL/Database Objects element, locate the relevant AF database and then remove the child element(s) representing the objects to delete:
Hope this helps.
I would like to know what kind of permissions you have to the config database in general. Are you an admin on the AF server? Can you see the config db when you open PSE? If so, could you send a screenshot of what permissions you have on the PI SQL element and its children?
I was running some tests on my server trying to specifically deny delete privileges to a test account but I couldn't get my SQL Commander in a state where the function was deleted in the client but not in the config db. If I denied delete and admin privilege for my user I go an exception that I wasn't allowed to delete my function in SQL Commander.
Retrieving data ...