INFORMIX ONLINE DYNAMIC SERVER

[CALYAN]

I WANT TO FIND THE NO. OF RECORDS IN A DATABASE. HOW TO FIND IT?(NOTE DATABASE NOT IN A PARTICULAR TABLE BY USING SELECT COUNT(*) FROM TABLE NAME)

 

[GRP]

Hi,

You can find the number of recrods in your database from the following sql:

select sum(nrows) from "informix".systables

G.R.P.

 

[jbcamel]

You need to add "where tabid > 100" to the above query or you will include the rows in the system catalog tables.

Jane

 

[GRP]

This can also be done by using where clause.

where owner != "informix".

Since he wanted to know all the records in database, I did not include where condition.

G.R.P.