From the course: Azure Data Studio Essential Training

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Write SQL queries

Write SQL queries - Data Studio Tutorial

From the course: Azure Data Studio Essential Training

Start my 1-month free trial Buy for my team

Write SQL queries

“

- [Instructor] One of the most common tasks that you'll need to do with any data table is review the data that it stores. You can do that by writing a select query, and Azure Data Studio has a way to get you started with a new query built right into the right click context menu. Let's take a look at the Kineteco database that's on the SQL server instance. We can expand the database, and then we can expand the tables folder. And we'll see that this database only includes a single table called dbo.department. Expanding the table will reveal its contents. Here, we can see that this table is made up of three columns. We have their column names, their data types, and any other constraints on each of those columns. We can also see if it has any keys. And this one does. It has a primary key on the department ID column. We can also see if it has any constraints, triggers, indexes, or statistics by expanding each of those…

Contents