The SQL Server system objects table includes entries with xtype that correspond to which objects when xtype equals U?

Study for the SANS560 GIAC Penetration Tester (GPEN) Test. Study with flashcards and multiple choice questions, each question has hints and explanations. Get ready for your exam!

Multiple Choice

The SQL Server system objects table includes entries with xtype that correspond to which objects when xtype equals U?

Explanation:
In SQL Server’s system metadata, xtype is a code that indicates the kind of object. A value of U means a user-defined table. So entries in the system objects table with xtype = U are the user tables created by users (as opposed to views, stored procedures, etc.). In modern catalogs this same idea shows up as type = 'U' in sys.objects, confirming they are user tables.

In SQL Server’s system metadata, xtype is a code that indicates the kind of object. A value of U means a user-defined table. So entries in the system objects table with xtype = U are the user tables created by users (as opposed to views, stored procedures, etc.). In modern catalogs this same idea shows up as type = 'U' in sys.objects, confirming they are user tables.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy