Forum Topics Tagged [create-table]

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 city should be the name of table in example. Thanks :)

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 number PRIMARY KEY, Dept_Name varchar2(25) NOT NULL UNIQUE, City varchar2(50) NOT NULL, Budget_Code char(5) NOT NULL UNIQUE, Mailstop char(3) NOT NULL);[/CODE] The constraints are in all caps. Also, I need to know how to do multiple constraints. Can someone help me on this? The second table I have:[CODE] create table …