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?
<SPAN class="keyword token">select</SPAN> i<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">as</SPAN> name<SPAN class="punctuation token">,</SPAN> t<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">as</SPAN> <SPAN class="keyword token">type</SPAN>
<SPAN class="keyword token">from</SPAN> sde<SPAN class="punctuation token">.</SPAN>gdb_items_vw i
<SPAN class="keyword token">join</SPAN> sde<SPAN class="punctuation token">.</SPAN>gdb_itemtypes t
<SPAN class="keyword token">on</SPAN> i<SPAN class="punctuation token">.</SPAN><SPAN class="keyword token">type</SPAN> <SPAN class="operator token">=</SPAN> t<SPAN class="punctuation token">.</SPAN>uuid
<SPAN class="keyword token">where</SPAN> i<SPAN class="punctuation token">.</SPAN>definition <SPAN class="operator token">like</SPAN> <SPAN class="string token">'%Versioned>true%'</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
