[create-table] Forum Topics

hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and …

i have two tables [ICODE] Articles id bigint 20 unsigned pk autoinc date_modified datetime name varchar title varchar content text Tags id bigint 20 unsigned pk autoinc name varchar [/ICODE] and i want to create this third table from above two tables [ICODE] Articles_Tags article_id bigint 20 unsigned tag_id bigint …

This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID …