Can anyone help me with this command? I am fairly new to it,and I am not sure ho

Question

Can anyone help me with this command? I am fairly new to it,and I am not sure how I would go about with this question.

Does anyone know the command that will show how manytables exist in the directory?

Is it something dealing with the SHOW command? If so, can someoneplease explain it to me and how I would find out how many tablesexist?

Thanks.
C Can anyone help me with this command? I am fairly new to it,and I am not sure how I would go about with this question.

Does anyone know the command that will show how manytables exist in the directory?

Is it something dealing with the SHOW command? If so, can someoneplease explain it to me and how I would find out how many tablesexist?

Thanks.
C

Explanation / Answer

please rate - thanks use the information_schema.tables   (YOURDBNAME is thename of your data base) USE YOURDBNAME SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table'

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.