Basically, the memory system of a video card is independent of the mainboard.
That is, all things equal, a DDR video card will perform the same on a system using SDRAM or DDR SDRAM.
In the real world however, most applications are not limited by only the performance of the video card so that same video card on a DDR system will perform better because it's in a faster computer.
It's kinda like asking will a DDR video card work better on a 1GHz P3 or a 2Ghz P4 computer. It will work fine in both but the overall system speed will be faster with the P4.