Cannot create table?

Hi i am trying to create a table called 'ITEM' with the following code:

-- Creation of Item Table
DROP TABLE ITEM CASCADE CONSTRAINTS;
CREATE TABLE ITEM(
ITEMID  NUMBER (6)      NOT NULL,



);

Code (markup):

I'm executing using @table.sql and i get this error message

SQL> @table.sql
DROP TABLE ITEM CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


Input truncated to 2 characters
unknown command ")" - rest of line ignored.

Code (markup):

After executing the script i should get a message saying' table created' but i don't. Bear in mind that i have not populated it. Should this affect it? It shouldn't should it?

 

Why do you have the first line dropping the table, if it hasn't even been created yet? That looks to be the problem.

 

Yeah, remove the drop line or add an IF EXISTS condition.

 

I think you can jsut click on the left side of the phpadmin where there will tables

you should click on top where it will show no of tables like this (4)

if you click on this it will ask for table name and the fields you can choose whatever you want and then press go

thats it

the table would be created

 

^^^ But I think the OP would like to do this with a SQL command.