CODEWITHSUNDEEP
sqlazure-sql-databasedatagrip
Mitch Wilkins
Mitch Wilkins

Reputation: 505

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

Upvotes: 11

Views: 8409

Answers (2)

moscas
moscas

Reputation: 10355

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

Upvotes: 14

Mitch Wilkins
Mitch Wilkins

Reputation: 505

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

Upvotes: 3

Related Questions