Subtitles of the Movie

Let's take a look at a few examples from the System Catalog. Now please remember when you're working with the System Catalog you're going to be creating a query. I'm only showing you a few simple examples. You can get very in depth depending on the query that you actually write. In this first example I've asked it to just select everything from the System Catalog specifically regarding the users. What I get in exchange is a list of users that are right within the system itself. Notice that it tells me their identification number, their name, and the role that they've actually been given. If I go to another example, I can now look at different information. In this particular case, I'm looking at Adventure and I'd like to see all of the user-defined tables. Now since it's a query I'm simple going to execute it. When I execute the query you'll notice now it gives me a list of all the user-defined tables. Notice that it's also giving me the creation date along with the modification date of the table itself. Moving on to another example, I can go even further by executing a query and finding out individual columns within the tables themselves. So you'll notice in this particular case I'm looking at the columns in the table specifically called Contact. I've asked it to give me the ColumnID along with the COLUMN-NAME. Now as you usual, when I go to the messages, I can see how many rows were affected by this. Of course we can always run an execution plan because we're just running a query in the background. Let's do one more example. In this example, I'd like to see what everybody has modified within the database itself. Again, I'm going to execute the command. Now on my particular case I'm using a sample database where there isn't any live data that's really being changed. There's no modifications going on in the background. So as a result I'm not seeing any stats on the bottom of the screen. In a production environment of course, this would not be the case and you'd be able to see the object, the schema, specifically what type is being changed, when it's created, when it's modified. On the top of it you notice that's exactly what I'm asking for within the schema itself. I'd like it to show me the object, the type, the creation and the modification date. These are all the different components that could be changed. If for instance that I wanted to see something within the last ten days, I could put ten in, execute my query again and it would show me anything from those particular dates. These gives you a lot of diversity with actually working through your database and within your sever itself. Take some time. Look at the different features that could be involved. Review the list that was included within our last video on the actual events that can be tracked within the System Catalog. See what's gonna work for you. Remember, some of us may not need to access the information within the system catalog. All of the different items that we're talking about really have to be specialized within your case. And as always remember, whatever you do within your server, make sure you have a good backup first.