Link to home
Start Free TrialLog in
Avatar of brgdotnet
brgdotnetFlag for United States of America

asked on

When creating a Sybase table, I get error message :Specify owner.objectname or use sp_help to check wether ....

I need help from a Sybase Expert.
I need to be able  to create a table in my database from scratch.  So I have a master script that creates all of the tables from scratch. For one of the tables, call it "EmpList" when I try to create that table from scratch I get the error message shown below. As a side note, I generated the sql to create the table by right clicking on the table in Aqua studio, and selecting "Script Object to File As : Create".

Why am I getting the error message below(See very bottom of post) when I try to create the table?
Here is my sql to create the table:

CREATE TABLE dbo.EmpList (
EmpId numeric(10,0) IDENTITY NOT NULL,
DtCreated datetime NOT NULL,
CONSTRAINT EmpList_pri PRIMARY KEY NONCLUSTERED(EmpId)
WITH max_rows_per_page = 0, reservepagegap =0
)
LOCK ALLPAGES
WITH max_rows_per_page = 0,
reservepagegap = 0,
identity_gap = 0
ON [default]
GO
GRANT SELECT, INSERT, UPDATE ON dbo.EmpList TO jeltem
GO
GRANT SELECT, INSERT, UPDATE ON dbo.EmpList TO admin
GO





> Script lines
dbo.EmpList not found. Specify owner.objectname or use sp_help to check wether the object exists (sp_help may produce lots of output)
ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of brgdotnet

ASKER

Never mind Sir, the issue has been resolved