Multiple choice sql

View text definitions are stored in which system table?

  1. sysobjects

  2. syscolumns

  3. syscomments

  4. sysviews
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SQL Server, the syscomments system table stores the actual text of views, stored procedures, triggers, and rules. The sysobjects table contains the names and types of objects, but not their underlying source code.

Keep practicing — related questions