How delete the empty not compiled table ?

ik

How delete the empty not compiled table ?
Form Object Designer NAT is closed with error.
Table have not keys, records and not compiled.
It's not opened, run.

From MS SQL tools table not exist.

Thanx.

lakshmivalluru

Hi ik,

I got to tell u i didnt get a point of what you are tryign to say.
But let me try, is it that you are not able to delete a table?
whats happening when you are compiling?

do one thing, in worst case, try this : take a backup of application objects and data seperately. take a standard database, import the backup , when the import worksheet is opened, skip the object you want to delete and replace the rest. then restore the backup of data.

hope you understood.

ik

Thank you.

NAT can't perform compilation of empty table, can't do
any operation with it (design, run, export-import).
NAT can't finish action. Appears OS system error and NAT is closed.
That's all.

About export - import objects and data:
Size of SQL-db is about 30 GB. I think it'll be too complex
operation in this case.

Anyway thank you very much for help.

Is There more simple method to delete empty not compiled object
in NAT ?

PS. Sorry for my english, studied by itself.

RobertMo

Make a new table with some fields.
Export it as txt.
Open in notepad and edit object number and name to match your problematic table.
Save and import this txt.
Try to compile/design/delete your problematic table.

nelson

What about selecting the Table in Object Designer and pressing F4?

ik

NAT is closed with system error in all cases and
can't finish operation.

Warfox

Hy,

what for an error does appear? Can you describe it better?

ik

finsql.exe - is discovered mistake.
Application will be closed.

kine

Which version of client you are using? Can you export this object into FOB? If yes, try import it back - DELETE option can be selected, after import object is gone... if first export end with error, try it again. Sometime first export end with error for empty objects... 8)

ik

I'm using NAT Client 3.10A.
I've got export fob just from second time, but import object did not delete
of my favorite table.

I think with NAT Client 3.10A this mission is impossible.

kine

What about

  Obj: Record 2000000001;

  Obj.GET(Obj.Type::Table,'',ID);
  Obj.DELETE;

Where ID is ID of your table? :?:

ik

I've got such result. NAT Client down with OS system error.
Kine, you have prompted to me where can I find decision of this
trouble.

I found record with required table in <dbo.Object> using
SQL Query Analyzer. I think I'll delete this table in short time.

Thank you very much for help.