mike99c
asked on
Cannot create SQL server express 2005 table using the query window.
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?
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?
Last Comment
ASKER
I am logged in using the same user that is also the owner of the database.
When I ran your script it showed I was connected to the master database.
I ran the create query with the dbo. prefix and I still get the same problem. The table is nowhere to be seen but the database still thinks it is there as I cannot run the query again with the same database name.
There are only 2 databases in the Enterprise manager and I cannot fnd it there either.
When I ran your script it showed I was connected to the master database.
I ran the create query with the dbo. prefix and I still get the same problem. The table is nowhere to be seen but the database still thinks it is there as I cannot run the query again with the same database name.
There are only 2 databases in the Enterprise manager and I cannot fnd it there either.
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
please can you post the entire create script?
in the sql you have a synax error in "," before ")"
in the sql you have a synax error in "," before ")"
ASKER
Thanks angellll, your were right it was in the master database. I am new to SQL server so was not aware of this.
I now right clicked on the database I wanted to create the table in and selected "new query". I then refreshed the tables and it appeared there. I will award you the full points.
I now right clicked on the database I wanted to create the table in and selected "new query". I then refreshed the tables and it appeared there. I will award you the full points.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
what database are you connected to when you run the script?
I assume in the master database, please check with this query:
select db_name()
and you are not looking in the correct database.
also, you should specify the user when creating the table....
CREATE TABLE dbo.TestTable
(
ID INT NOT NULL,
ItemCatRefID INT NULL,
ItemRefID INT NULL,
PageNumber INT NULL,
DisplayOrder INT NULL,
)