ALL YOU WANT TO KNOW ABOUT VIEWS
WHAT IS A VIEW?
In a short sentence, a view is a “saved query” associated with a name. Once you create the view (or save the query), you can use it as a table in other queries. Trying to explain with more detail what a view is, we can say that a view is another type of database objects like tables, indexes or stored procedures. From the point of view of a developer who is trying to write a SELECT query, a view is like any other regular table. The view can be used in the FROM clause as any ...
Table Structure Previews
One of TeamSQL’s newest features is the ability to preview the structure of a particular table. You’ll be able to view the table’s column definitions, as well as information about any indexes that might be on the table.
You can access this information in one of two ways: the first is to open up a pop-up window containing the table structure information, and the second is view it in the Connections Pane.
Begin by hovering over the name of a table in the left-hand ...