Cannot create SQL server express 2005 table using the query window.
Posted on 2007-03-24
I have SQL Server Express 2005 and I am trying to create a table by clicking on the "New query" button and executing the following query:
CREATE TABLE TestTable
ID INT NOT NULL,
ItemCatRefID INT NULL,
ItemRefID INT NULL,
PageNumber INT NULL,
DisplayOrder INT NULL,
The result was:
Command(s) completed successfully
However, the table is nowhere to be seen. I refreshed and opened and closed the database but still no good. When I execute the query again it says the table still exists. In the end I was able to manually create the table.
Does anyone know what I am doing wrong?