Catalog View and Information Schema - T-SQL Step by Step Course - Lesson 16 | SQL courses

Duration: 19:36 min

Summary: In this video, we will continue our discussion on catalog views. As we quick recap: we know that there are many ways of getting information about the database (the list of tables, views, functions, stored procedures, columns…). In our case within T-SQL, we are looking at three source of information: (1) Catalog views. We will continue this discussion today to learn more ways of getting database metadata. (2) Information schema: this information schema is more ANSI compliant. So we can see that being standard across other database venders (like Oracle). Today, we will also see how to use this schema to get database information. (3) System stored procedures. Those procedures will give us tons of information about the database objects. For example, we will see how to use sp_help to get lots of details about specific tables.