AnsweredAssumed Answered

Using Python to print a "database view definition"?!

Question asked by RRodriguez3@isd.lacounty.gov_lacounty on Apr 5, 2018
Latest reply on Apr 6, 2018 by bixb0012

I am attempting to interrogate an SQL Server Enterprise Geodatabase using Python. I want to obtain information for all features, relationships, tables etc. within said database. (I have only been using python for about a week. So please be detailed.) 

 

I am having an issue with the TableViews. When using the walk function, with a datatype of "Table", I can print the File Name, but not the WhereClause. (I can see the definition in the View Properties dialog box.) 

I'm not sure how 'off' I am in my procedure and syntax. I have been trying the following statement ||| desc = arcpy.Describe(TableViewName) print "Where Clause: " + desc.whereClause |||  (I pulled this from the TableView properties example on the ArcPy Help on ArcGIS.com.)

 

 Any ideas?! Thanks! 

 

 

Outcomes