How do I create a view in JetBrains DataGrip?

9
votes

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

2
sqlazure-sql-databasedatagrip
What's wrong with create view ...? – a_horse_with_no_name
I was just looking for something with a UI. Does this exist in DataGrip? – Mitch Wilkins
For now DataGrip has no UI for creating views. Please, follow and share your thoughts: youtrack.jetbrains.com/issue/DBE-132 – moscas

2 Answers

12
votes

There is no UI for this, but VIEWs are usually 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

3
votes

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