brgdotnet
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)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER