There is a very useful online tool called SQL Fiddle that allows you to build test tables, populate them with data & run queries on them. This is great if you are trying to figure out how you should set up a database or if you are having trouble trying to figure out a complex query as it allows you to quickly run tests without having to build & deploy an app to a device or simulator.
- Colin.
- Colin.