🎴 Flashcard Mode
databases Online Quiz - 2
Card1 / 20
Mastered0
Review0
QuestionClick to flip
How to find out no. of objects in a database.
AnswerClick to flip back
A
select * from Sys.sysobjects
💡 Explanation:
The sys.sysobjects system view contains one row for each object in the database, making it ideal for counting objects. While sys.objects is preferred in modern SQL Server versions, sys.sysobjects is also available. The other options are either invalid procedures or incorrect dynamic management views.