)How will you enlist the name of database and the tables in a database?
Share
)How will you enlist the name of database and the tables in a database?
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
If you want to know how many tables are present in your database and the details of the table like TABLE_SCHEMA, TABLE_TYPE and all.
Syntax (When we have only single database): ...
Syntax (When we have multiple databases): Select * from database_name.schema_name.table_name.
Example: ...
WHERE.
Answer:
Hello
Nice to meet u after a long time
I'm fine ,
have a bangtas.tic , Buttery and purplish day ahead