how to judge a db table is empty or not.

[Former Member]

Hi All,

how to judge a db table is empty or not. don't use select clause

[Former Member]

from se11/16 check no of hits.

Regards

Prabhu

[Former Member]

Hi..,

You can check this from Tcodes SE11 or SE16..

or from the program also u can check that..

write a <b>select *</b> query on that table without any conditions and check the value of <b>sy-dbcnt</b> after the select statement !!

<b>SY-DBCNT eq 0 </b>, for an empty table after select *..

regards,

sai ramesh

[Former Member]

Hi

Use Describe

[kiran_k8]

Johny,

The statement DESCRIBE TABLE sets the system fields sy-tfill and sy-tleng.

and the system fields sy-tfill and sy-tleng are filled with the current number of table rows and the length of a table row in bytes.

use tcode ABAPHELP for more info.

K.Kiran.

[Former Member]

Hi.....

you can communicate with Database only with Select statement(SQL)

There is no other way except SELECT CLAUSE.

if you want to it manually use the transaction SE16.

Regards,

Suresh..

[Former Member]

As the database tabel is at different server, SAP has to use SELECT statemnt to know the Number of record programatically

Otherwise check manually using SE11/SE16 transaction & get the number of hits

[Former Member]

Get Solution from internal colleague