CREATE TABLE is not working correct
-
Greetings,
any ideas why this statement, although creating the table is not creating the field [buchungsid]???
CREATE TABLE [dbo].[report9] (
[report9_id] [int] IDENTITY (1, 1) NOT NULL ,
[buchungskreis] [char] (10) NULL ,
[lfd_nr] [int] NULL ,
[buchungsid] [int] NULL ,
[valuta_datum] [smalldatetime] NULL ,
[buchungs_text] [char] (50) NULL ,
[buchungs_datum] [smalldatetime] NULL ,
[sap_soll] [char] (6) NULL ,
[sap_haben] [char] (6) NULL ,
[betrag] [decimal](18, 2) NULL ,
[zuordnungsnr] [int] NULL
)
GO
It is only not working in the db where it should be. In any other db it is working correctly. this table extisted before and I dropped it using EM. Anything forgotten?
Cheers,
Frank
Edited by - a5xo3z1 on 04/25/2003 06:08:37 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I just ran your code and it worked for me but I have had the same types of problems when you do things with enterprise manager. Try building the table and then dropping it from Query Analyzer then run your code again and see what happens.
-
Seems to be weired. When I use another table name it is working
Of course I can work around this, but I don't like to. There must be something missing!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I could not duplicate the issue. Where are you running this from?
-
Running from QA 2k on a SQL 7 db.
Never had problems with this.
Everything else is working. Changing db, changing table name. I do the workaround, for i haven't got the time. Maybe later I'll try again to find out.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply