what would the syntax be to create a new table???
CREATE TABLE table (field1 type [(size)] [NOT NULL] [index1] <BR> [, field2 type [(size)] [NOT NULL] [index2] [, ...]] <BR> [, CONSTRAINT multifieldindex [, ...]]) <BR>
Should.... By the way what Database are you using ? Oracle or SQL Server ? From Where are you trying to create this table , I means Is it SQL PLus (in case of Oracle) or is it from Query Analyzer (In case of SQL Server) or using any Wizard ?
WELL ITS FROM AN ASP PAGE THAT I WANT TO CREAT THE TABLE. AND **wispers** the db is ms access!
What you posted will work.