Multiple choice technology databases

sys.sql_modules system catalog contains a row for each object of type P, RF, V, TR, FN, IF, TF, R, and D.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The sys.sql_modules catalog view returns a row for each object that is a SQL language module. This includes stored procedures (P, RF), views (V), triggers (TR), scalar functions (FN), inline table-valued functions (IF), table-valued functions (TF), and rules (R). The type codes listed match SQL Server's object type catalog entries.

Keep practicing — related questions