Hi guys, I'm playing around with creating an app for my pocket pc and I need a small database for it.

I've already managed to create the database itself on the device, but I need a way to add tables and columns to those tables and establish relationships. Is there a GUI way to do this? I know I can do it in code, but I'm not that sharp with SQL.

I'm using VS.2005. I've added the database as a datasource and I can create the tables and stuff that way, but it appears that it's only a dataset and not the actual database file. Is there a quick way I could just update my dataset to the database?

Sorry if these are newb questions, I just haven’t had the time to devote to getting good at database programming.

Thanks for any help