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 Jul 12, 2025
-> HTET Exam Date is out. HTET Level 1 and 2 Exam will be conducted on 31st July 2025 and Level 3 on 30 July
-> 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.