After unregistering as versioned all objects in a schema the simple relationships still show up as versioned when I check with sql. There is also one feature dataset that has the same problem. When I check the feature dataset with ArcCatalog it gives me the option to register as versioned. So, I think the sql query is not telling the whole story... Why is this happing?
select i.name as name, t.name as type from sde.gdb_items_vw i join sde.gdb_itemtypes t on i.type = t.uuid where i.definition like '%Versioned>true%'
I tested this in my test SQL Server DB and it worked as expected when I unversioned a FC. I looked at the xml file within the gdb_items table.
So, it looks a little buggy to me--like the xml in the gdb_items_vw is not getting updated when the other sde system tables are. (We are on Oracle).
I would recommend working with Tech Support and an analyst on this behavior.
Fair enough George. Thanks for the input.