Question
Download Solution PDFThe names of the tables that an user can have access to or that he or she has created, can be displayed with the following SQL query:
Answer (Detailed Solution Below)
SELECT table_name
FROM User_tables;
Detailed Solution
Download Solution PDFQuery Syntax for listing the tables in SQL
- Show all tables owned by the current user
SELECT table_name FROM user_tables;
- Show all tables in the current database
SELECT table_name FROM dba_tables;
- Show all tables that are accessible by the current user
SELECT table_name FROM all_tables;
Therefore, Correct answer is Option 1
Last updated on Jun 6, 2025
-> The HTET TGT Applciation Portal will reopen on 1st June 2025 and close on 5th June 2025.
-> HTET Exam Date is out. HTET TGT Exam will be conducted on 26th and 27th July 2025
-> Candidates with a bachelor's degree and B.Ed. or equivalent qualification can apply for this recruitment.
-> The validity duration of certificates pertaining to passing Haryana TET has been extended for a lifetime.
-> Enhance your exam preparation with the HTET Previous Year Papers.