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.

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...

This will pop open this view...

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/.