Saved Bookmarks
| 1. |
)How will you enlist the name of database and the tables in a database? |
|
Answer» 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. |
|