Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In SQL Server it shows records and geometry but when it comes to ArcGIS it does not show table or geometry in ArcGIS Desktop 10.1.
enter image description here.
It shows only the geometry in ArcCatalog but not the table in preview table.

Below is my code:

SELECT SPE.[OBJECTID] ,SPE.[BaseId], SPE.[PlayId] , B.[BasinName], SP.[ShaleName], AGS.[AgeS],  SP.[Ref] , SPE.[Shape] , SPE.[Shape_STArea__], SPE.[Shape_STLength__]
    FROM [dbo].[Play] SPE inner join [dbo].[Base] B on SPE.[BaseId]=B.[OBJECTID]
        inner join [dbo].[shale] SP on SPE.[Shale]=SP.[OBJECTID]
        inner join [dbo].[Age] AGS on SPE.[AgeId]=AGS.[OBJECTID]
share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.