All Forums Teradata Studio
roslyn.wade 2 posts Joined 02/14
23 Jun 2014
I'm new to Teradata. My Select statements saved to Project Explorer save as .txt not .sql. How to chg default?
fgrimmer 553 posts Joined 04/09
23 Jun 2014

If you save a file from the SQL Editor (New SQL Editor or create a new file from the SQL project - right click > New> SQL File), it will default to .sql extension.  

roslyn.wade 2 posts Joined 02/14
11 Jul 2014

Thank you for your answer. When I'm saving, the background screen says it's saving to SQL but once it saves, the extension is still .txt. Then when I pull up the 'sql' to run it again, it's still being treated as text and won't run. Maybe there's something wrong with the way we have it set up.
Thanks for trying.
 

fgrimmer 553 posts Joined 04/09
14 Jul 2014

Roslyn, The 'SQL' project is created as a default project folder when Studio is first launched. It can contain text, Excel, or SQL files. To default to the SQL extension, you would need to create the file using the New> SQL File or give it the SQL extension when you Save.

You must sign in to leave a comment.