I have two SQL table with same columns/field name, but when I open both tables in ArcMap it shows different information in Source Tab.

enter image description here SDE table type shows all of the fields where query table type missing one field in ArcMap though all same field I can see from SQL Server end.

I am using ArcMap 10.2 also I checked in pro and same thing is happening.

I'd like to know

  • How I can change Query Table to SDE table.

  • Any idea why two identical tables with field name, one showing all field and other one is missing which is Date type column?

  • In most contexts, the difference between a Query Table and an SDE Table is rather fine. You've removed so much information that it is quite difficult to judge how these objects were created. Usually ArcGIS doesn't let you use the table at all if the type on one column is unsupported.
    – Vince
    Jun 26, 2018 at 18:13
  • So here what happens...In ArcMap , when i bring SDE type table from connections to layer window i don't get any pop ups and i can see all fields which i wanted to see. When i bring query type table, then i get pop up window 'New query Layer window' when i hit finish it adds to the Layer and then i am not able to see all fields basically one column is missing which has date data type in sql.
    – SQLLogic
    Jun 26, 2018 at 19:44
  • Please Edit the question to provide this information. As OP, your duty is to improve the question. The difference is that one of the two tables is registered with the geodatabase.
    – Vince
    Jun 26, 2018 at 21:34
  • Thanks Vince.. seems like your suggestions worked very well. I did registered with geodatabase and i was able to see missing field.
    – SQLLogic
    Jun 27, 2018 at 15:58


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.