From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Explore the system tables
From the course: Database Foundations: Database Management
Explore the system tables
- [Instructor] One of the more interesting aspects about relational database management systems at least to me, is that they use internal system databases and tables to manage your personal databases and tables. The thing that I find interesting is that it's exactly the same database objects that are used. System tables are just regular relational tables made up of columns and rows that store attributes about how your databases are built. So when you create a table, that information is saved into a system table. When you update the data type that I a column holds, that information is also saved into a system table. System tables hold the building blocks for the relational databases that you develop. The wonderful thing about this is that these tables are often available for you to read through and they can provide a wealth of information about how your database is constructed and the settings and options that are enabled. This can be done with standard select queries as long as you…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.