Tables, Cells and Table Records in SQL

SQL Database Tables and Their Cells: In SQL Server database, ‘table’ is the object holding the database information. Now, as the table is the most central part of any SQL database, the information that it contains must be organized carefully and systematically. For better management of this information, all the data contained in a table is set in a series of fields, which are called ‘cells’. You can review this information contained in the table either by using SQL Server Management Studio or with the help of an external application. The tables of an SQL Server database are displayed in the Object Explorer under their database node. For opening a table for data entry, you can right-click that table and then, click ‘Edit Top 200 Rows’.

Navigate through SQL Table Data using SQL Server Management Studio: Data navigation is for making the data displayed and viewed. Now, as all this database information is contained within the tables, so your principal step towards data viewing will be to open a table in a view that will display its information.

Navigate through Records: On viewing a table, when the records of that table are displayed, you can navigate through those fields using your mouse or keyboard. For navigating through records using mouse, you can simple use the mouse for getting into any cell, and after that, you can just click it.

Navigate through Records using Keyboard: For navigating through the table records using the keyboard, you can take note of the following points, where, the functions of several keys of the keyboard are described: 

• Right Arrow Key: The right arrow key is for moving to the right cell. In case, the caret is already in the extreme right cell, then it would get moved from there to the first cell of the next record, up to the last empty cell of the first empty record
• Left Arrow Key: The left arrow key is for moving to the previous or left cell. In case, the caret is already in the extreme left cell, or reaches the most left cell of the first record, then nothing is going to happen on pressing the left arrow key
• Down Arrow Key: The down arrow key is for moving to the cell, which is present under the current cell. In case, the caret is already in the last cell of the current column, then nothing will happen on pressing the down arrow key
• Up Arrow Key: The up arrow key is for moving to the cell, which is just above the current cell. In case, the caret is already in the first cell of the current column, then nothing will happen on pressing the up arrow key 
• Page Down Key: The Page Down key is for moving to the next group of cell that corresponds to the next page. In case, the number of records is less than a complete page, then the caret will be moved to the last cell of the current column
• Page Up Key: The Page Up key is for moving to the next group of cell that corresponds to the next page. In case, the number of records is less than a complete page, then the caret will be moved to the first cell of the current column