valid table name?

[dai_lo]

CREATE TABLE [X.Y.TEST]
(
Test1 decimal(38,0) NULL,
Test2 decimal(38,0) NULL,
Test3 decimal(38,0) NULL
)
go

IF OBJECT_ID('[X.Y.TEST]') IS NOT NULL
PRINT '<<< CREATED TABLE X.Y.TEST >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE X.Y.TEST >>>'
Go



is [X.Y.TEST] tablename?

I execute the above ddl in MS SQL 2000 and then extract it using ER/studio. Er/studio only extract the table without the columns

please advise

[MAK]

[X.Y.TEST] is a valid table name in sql server 2000. What version of ER studio you are using?

[dai_lo]

i am using ER661 3892