SQL In OpenOffice??

[flipjargendy]

If someone sent me a .sql file should i be able to open it in OpenOffice Base?

[bigtomrodney]

It doesn't seem to be in the list of 'openable' files. I do know that you can run sql queries in Base so maybe it runs that way. As with all sql scripts it is a bad idea anyway to associate them with an application. I would suggest it should work if

• It is creating a new database as part of the script
• It refers to a database and tables you have already

SQL scripts are quite dangerous when used improperly, make sure you check the connection/db file first

[flipjargendy]

Thanks Turns out I won't be needing to do anything with the file. I'm starting from scratch now.