![]() In the DDL editor, you can change the source code. If you want a script with qualified references, use the SQL generator. The reason for this is the ability to copy the script for applying it in another context. Important! The object references in the generated script are not qualified, in other words, %view_name% is used rather than the %schema_name%.%view_name%. Here you can find the CREATE script for the object. In case of the view, double-clicking on it in the database explorer opens the data: to open the DDL explorer click on the DDL button in the toolbar. ![]() The flowĭouble-clicking on the object in the database explorer or pressing Cmd/Ctrl+B on it in the SQL script opens the DDL editor. Handling this situation will be covered later in our tutorial. You might be asking: if the source code is loaded when introspection is performed, doesn’t it mean that they are out-dated? In Oracle there is the possibility not to load sources by choosing a lower introspection level: ![]() You can manage this process by choosing the required value in the Load Sources for options in the data source properties. This means that all source code is loaded when the introspection is performed. Loading sourcesįor any data source, DataGrip performs the process called ‘introspection’ – the IDE retrieves all the metadata for objects in advance. This is not the way you are supposed to update the source code. People coming from other tools all make the same mistake: they open the DDL, copy it, modify it, adjust the CREATE statement (usually add the OR REPLACE part) and run the new script. You just need to make the changes you need to make and the proper script will be generated for you. In DataGrip it works a little differently. In many other tools, to update the source code, you would need to generate the CREATE OR REPLACE script, make the required changes and run it. The most common objects found with the source code are views, functions, and stored procedures. The source code is stored inside the database. In other words, the CREATE statement is not part of the object’s source code. The source code of the object is the core part of the DDL script which is needed to create this object.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |