SQL, Structured Query Language Data File (.sql)
The SQL Database file format
Files with the SQL extension contain code written in a certain language; the Structured Query Language (SQL). The code contained in the SQL file is used to modify the content of other, relational databases. SQL files can be used to delete, insert, extract or update data and information.
Technical details of SQL files
SQL files are written in a plain text (ASCII) format and may contain different information defined in the code. It can contain statements that either create or modify a database or other SQL operations such as updates, deletions and the like. To be properly read and executed, the SQL file has to be opened in a database program that supports the Structure Query Language. However, any simply text editor can be used to write and edit an SQL file.
More information about the SQL file format
|Associated programs||Altova DatabaseSpy (Windows)
Apple TextEdit (Mac)
Bare Bones BBEdit (Mac)
MacroMates TextMate (Mac)
MalcolmHardie Solutions SQLEditor (Mac)
Microsoft Notepad (Windows)
MySQL (Windows, Mac & Linux)
Richardson RazorSQL (Windows, Mac & Linux)
Other text editors
|Useful links||More about SQL files|