select count(1) from tab will give the total number of tables,views and s

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

Question Posted / gourvendra singh

Answer Posted / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Is This Answer Correct ?

61 Yes

6 No

Please Help Members By Posting Answers For Below Questions

explain advantages of innodb over myisam. : Sql dba

1124

What are different functions in sql?

938

What is keys and its types?

1069

In a distributed database system, can we execute two queries simultaneously?

1081

Is it possible for a table to have more than one foreign key?

1028

how tsql statements can be written and submitted to the database engine? : Transact sql

982

Which sorts rows in sql?

1014

Can a composite key be null?

971

How do you change a value in sql?

1011

Can we insert data into materialized view?

940

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

What is a record in a database?

1059

What found sql?

939

Why sql query is slow?

985

What is difference between cursor and trigger?

1067