Hi Sean ,

Thank you so much for answering and for your solution, your solution saved me hours and headaches

You were correct, it was a view

Here is the code in case someone is looking for this

SELECT st.name AS TableName

, sc.name AS ColumnName

FROM sys.objects AS st

INNER JOIN sys.columns sc ON st.OBJECT_ID = sc.OBJECT_ID

WHERE st.name = 'v_SEC_NON_SEC_POSN_F_TOTAL'

OR st.name = 'AMID_MAPG'

ORDER BY st.name

, sc.name

One more thing, I’ve been trying to do the same thing but with an excel file using a SQL query (Powerpivot) should I open a new post for that question or should I use this one ?