@rahul.gadodia, Teradata Studio does have a Generate DDL option. If you right click on the procedure in the Data Source Explorer, choose the Generate DDL menu option. The second to last page of the Generate DDL wizard allows you to open the DDL in a file. You can then save the file for version control.
I have hundred's of procedures. Can i select multiple procedures and then create separate script for individual procedures.so i want to create DDL script for procedures in separate sql script files.It would be very nice feature to have to maintain code control.Quest Toad has same kind of feature.
I like this product a lot, but is there any way the execution plan of queries can be formatted to make it easier to read similar to SQL Assistant? Right now you can toggle between text and grid, but it's a lot more work to try to read the execution plan when it's not formatted. I have to use SQL assistant when I want to see the execution plan for a query.
@em189001, There is not a way to remove database profile types from the list. There isn't really a way to disable the admin features. You can customize the Teradata Administrator Perspective and remove items from the toolbars and menus.
Also, you can import predefined connection profiles using the Import option of the Data Source Explorer toolbar or menu.