Aqua Data Studio Table Editor
Hello and welcome to Aqua Data Studio. Table Editor Overview aqua Data Studio a universal database IDE and visual analytics productivity tool used by It professionals that are working with data and databases. Aquadata Studio allows you to develop and manage your databases in a variety of ways in terms of performing database access, import, export, and having the ability to visually analyze your aqua data. Studio supports over 30 different database platforms and works on a variety of operating systems such as Windows, macOS and Linux. Finally, Aquadata Studio supports relational, NoSQL and cloudbased data sources, making your data easily and quickly accessible. Our agenda for today is going to be an introduction to the Table Editor.
Table Editor
Exploring the Table Editor, altering a table, editing the Table data, saving those changes, and finally viewing the new data. So let’s get started. Here in my IDE, I have my databases that I’m working with. Here I have a connection to a SQL Server database table. Here I’ve decided to pick the Adventure Works 2017 database and choosing the Human Resources schema and the Table department. What we’ll do here is I’ve gone ahead and issued a select statement that will get me the records of all the employees in this department. I’ll go ahead and run this and this brings up the result set.
Alter Tables
Now before we go ahead and take a look at how to edit this data, let’s better understand of how we can look at the Alter table option. Here if I go to the Alter table option, you will see that we do have the ability to look at the various columns that are listed here. If you wanted to, let’s say, add a new column. Let’s say I’ll give it a time, then here I’ll put a time here and what I’ll do is we can also go ahead and check out the constraints.
Now in the Constraints section here you’ll give we shown the list of constraints applied on that particular table and what columns it’s applied to. Then you have the storage group. It’s part of the primary file group here. That’s why it’s showcasing that extended properties are very important, especially in SQL Server. If you want to document anything to the table, like adding a table level comment, this is where you would go out and do it.
User Permissions
Next we go to the permissions. This gives you a list of all the permissions of the various users and roles. And that is pretty handy. If you want to go to a specific role you want to grant or revoke, you can choose that and perform those particular options. Here then finally, if you were to go to the preview SQL right now it’s saying there’s nothing change. It’s saying it’s an invalid data type, it requires a scale. So it is giving you a warning. Here we can go back and give it a scale or change or I could just go ahead and use the Timestamp. Now if you go and set this right now, it gives you the Alter Table statement.
Table Properties
Next, let’s take a look at the Table Properties section. In the Table Properties, it’s similar to the Alter. The only difference would be that there’s no messages as well as there’s no constraints, and where you can actually go ahead and perform any kind of edits. This is just a read only section so you can view it. This is very useful if you want to just get some metadata information. We will now move on to how we can actually go ahead and edit the Table Data. What we can do is we can actually go ahead and choose Edit Table Data. And this brings about the table editor.
Table Editor
This is specifically for the Table Data editor, where you can see the various list of options here. Now, among these rows, I would like to go ahead and make a change to the executive name. Here I’ll just call it as Executive Management. Hit Enter and before I commit the changes, you will see that I can actually go ahead and preview the SQL. And this generates the SQL for me. Also you have the ability to add either before or after a row. I can actually go ahead and insert a row before or I can insert a row after, and then if I do not want to have those, I can just go ahead and select the row and delete it. Again, if I go back here, it does not change the update statements in any shape or form. I can actually go ahead and hit Control S.
SQL Query Editor
Or I could go ahead and click on this button that says Save and Refresh. Right now it’s in Save and Refresh. If I were to go back to my query Editor here. Notice that right now the data is showing us executive I’ll go ahead and rerun this. And now we should see Executive Management. In summary, Aquadata Studio provides extensive capabilities to improve productivity for developers, analysts and DBAs. It also helps you to perform data visualization, database administration and much more. To learn more, go ahead and head to Dubdub Aquifer.com to experience a free trial today. And I thank you for your attention.