For a while now a small bug has impacted RDS dataviews in ColdFusion Builder. I love the built in data views in CF Builder, but this little bug has annoyed me for too long now.
![](https://static.raymondcamden.com/images/ScreenClip195.png)
This bug, and a workaround, are discussed here, but in the meantime, I thought, why not just write a quick CFBuilder extension to get around it. So with that in mind, I wrote "My Databasie View." Once installed, you can right click on any table...
![](https://static.raymondcamden.com/images/cfjedi/ScreenClip196.png)
This will pop open this view...
![](https://static.raymondcamden.com/images/cfjedi/ScreenClip197.png)
At which point you can edit the SQL and do whatever you want. The display ain't great, but I never realized how much I used the RDS "Show Table Contents" feature until it stopped working reliably.
You can download this at the RIAForge project I just set up for it - http://mydatabaseview.riaforge.org/.