He sits down at a little table in the corner.
He is sitting down. (direction >accusative)
The table is standing in the corner (location>dative)
It would be a different case if we said:
He sits down in the corner.
In this case we would have a movement into the corner. >Accusative
Er setzt sich in die Ecke.