Toad World® Forums

RE a MSSQL 2k8 database and views have no attributes


#1

I am reversing a MSSQL 2k8 database and all the views that it picks up dont have any attribuites. for example the SQL preview is:

CREATE VIEW [ERROR_TEXT_VIEW1]
AS

go

If I RE the same database from Oracle or DB2 I get:

CREATE VIEW “ERROR_TEXT_VIEW1”(“ERT_LINE_NUMBER”,“TEXT_LINE”,“FK_ERL_PROG_NAME”,“FK_ERL_SEQ_NUMBER”,“FK_ERL_JOB_TIME”,“FK_ERL_JOB_DATE”,“FK_ERL_JOB_NUMBER”,“FK_ERL_JOB_NAME”,“TEXT_TYPE”) AS
SELECT
LINE_NUMBER,
TEXT_LINE,
FK_ERROR_LOGPROGRA,
FK_ERROR_LOGSEQUEN,
FK_ERROR_LOGJOB_TI,
FK_ERROR_LOGJOB_DA,
FK_ERROR_LOGJOB_NU,
FK_ERROR_LOGJOB_NA,
TEXT_TYPE
FROM ERROR_TEXT

Does anyone know why?


#2

Hi,

Please do you have somewhere the original command via which you created the view?
When we create what RE returns you from Oracle and DB2 in the database, it is loaded correctly during RE of MS SQL.

If we understand well, the only problem you encounter is that column names were not loaded. Right?
“ERT_LINE_NUMBER”,“TEXT_LINE”,“FK_ERL_PROG_NAME”,“FK_ERL_SEQ_NUMBER”,“FK_ERL_JOB_TIME”,“FK_ERL_JOB_DATE”,“FK_ERL_JOB_NUMBER”,“FK_ERL_JOB_NAME”,“TEXT_TYPE”

Regards,

Vladka + Mario


#3

The view is created as:
CREATE VIEW ERROR_TEXT_VIEW1
(ERT_LINE_NUMBER,
TEXT_LINE,
FK_ERL_PROG_NAME,
FK_ERL_SEQ_NUMBER,
FK_ERL_JOB_TIME,
FK_ERL_JOB_DATE,
FK_ERL_JOB_NUMBER,
FK_ERL_JOB_NAME,
TEXT_TYPE)
AS SELECT
LINE_NUMBER,
TEXT_LINE,
FK_ERROR_LOGPROGRA,
FK_ERROR_LOGSEQUEN,
FK_ERROR_LOGJOB_TI,
FK_ERROR_LOGJOB_DA,
FK_ERROR_LOGJOB_NU,
FK_ERROR_LOGJOB_NA,
TEXT_TYPE
FROM ERROR_TEXT

go

Its created the same way on Oracle.


#4

Hello,

Thanks for your reply.
A hard thing. It works fine for us. We used the command and it was loaded properly again.
Unfortunately, we don’t know what to advise…

Regards,

Vladka + TDM Team


#5

I got it working thanks.