Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I create a view in JetBrains DataGrip?

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...'

like image 561
Mitch Wilkins Avatar asked Nov 03 '17 19:11

Mitch Wilkins


2 Answers

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

like image 36
Mitch Wilkins Avatar answered Oct 13 '22 14:10

Mitch Wilkins


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

like image 119
moscas Avatar answered Oct 13 '22 15:10

moscas