How do I create a view in JetBrains DataGrip?

user_6885687 0
Viewed 7060

I am using an Azure SQL database with DataGrip. I would like to create a view connecting certain tables within my database.

Does DataGrip have a tool for doing this? If so, how can I do it?

It's relatively easy in Microsoft SQL Server Management Studio. I would right click the Views folder and select 'New View...'

datagrip azure-sql-database sql
2 Answers

UPD: in the late version there is a UI for creating a view:

enter image description here

Views can be also created via raw SQL. In DataGrip you can generate it automatically via Generate action (Alt+Ins, Cmd+N for OSX) where several objects for generation are available.

enter image description here

user_57777990

According to other users' comments this feature does not exist at the moment.

user_68856870
Related