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...'
According to other users' comments this feature does not exist at the moment.
UPD: in the late version there is a UI for creating a view:
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With