select count(*) from dba_objects
Open in new window
With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.
select count(*) from sysobjects where xtype='U'
select count(*) from INFORMATION_SCHEMA.TABLES
SELECT COUNT(OBJECT_NAME) from user_objects where object_type = 'TABLE' -- Tables of current user
SELECT COUNT(TABLE_NAME) FROM USER_ALL_TABLES -- Tables of current user
SELECT COUNT(TABLE_NAME) FROM ALL_ALL_TABLES;--All object and relational tables accessible to the user, With User : System All Tables DB
SELECT count(TABLE_NAME) from Dictionary; --????
select count(OBJECT_NAME) from dba_objects where object_type='TABLE' --All database Tables . Login: System
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.