It returns the count of all tables for that user.

What does “select count(1) from tab” result?

Question Posted / phani

Answer Posted / phani

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

what is subquery? : Sql dba

1066

Is sql microsoft?

977

Explain the uses of a database trigger?

982

What are the constraints available in sql?

995

Can we join two tables without common column?

928

how to create a new table by selecting rows from another table in mysql? : Sql dba

1007

how many triggers are allowed in mysql table? : Sql dba

995

what is a materialized view? : Sql dba

996

how to analyze tables with 'mysqlcheck'? : Sql dba

958

what is a constraint? : Sql dba

1105

what is bdb (berkeleydb)? : Sql dba

974

how to enter numeric values as hex numbers? : Sql dba

1006

Define implicit and explicit cursors.

1074

How many clustered indexes can you have?

924

What is data abstraction in sql?

965