The Esri Community
Esri Technical Support
Esri Technical Certification
GeoNet Resource Hub
to create and rate content, and to follow, bookmark, and share content with other members.
SDE Layers Tool
Idea created by
on May 2, 2013
1 vote up
3 votes down
It would be nice to have a tool that creates a text file listing all of the layers in SDE. I have a script that exports layers into a file geodatabase for archiving purposes.
This content has been marked as final.
Show 1 comment
(Required, will not be published)
May 3, 2013 10:52 AM
You might want to expand a little on your requirements or exact needs with the text file. For what purpose would the text file be used for? There is already arcpy.ListFeatureClasses and this could be exported to a text file quite easily in python or use CopyFeatures to the archive geodatabase.
Additionally you could run traditional queries against sde.sde_layers table using Access, Excel or SSIS.
Another tool that might be useful would be the Geodatabase X-Ray tool. It can create XML or an HTML Data Dictionary of all items within an ArcSDE, File or Personal Geodatabase.
Show 0 Likes
Retrieving data ...
Vintage Business Summary data and Shapefiles
support ArcGIS Online Assistant
Kevin's Custom WAB Widgets
Extract Feature Attachments
Collector - The Aurora Project