What is the Difference Between Extension and Extention?

🆚 Go to Comparative Table 🆚

The difference between "extension" and "extention" lies in their spelling and meaning. "Extension" is the correct and widely accepted term, while "extention" is an incorrect spelling that lacks recognition and meaning.

  • Extension: This term refers to a component, action, or process that enlarges, prolongs, or extends something. It is used in various contexts, such as computer files, software, and physical components. For example, in computing, an extension is a suffix appended to the end of a file name, separated by a dot, indicating the file's format or type.
  • Extention: This term is an incorrect spelling of the word "extension" and does not have a separate or alternative meaning from the correct spelling. It is essential to use the correct term "extension" for clear communication and accurate file handling.

In summary, "extension" is the correct term used in computing and other contexts, while "extention" is an incorrect spelling that should be avoided.

Comparative Table: Extension vs Extention

The terms "table extension" and "table extention" seem to be slightly different concepts in different contexts. Here is a table comparing the two concepts:

Table Extension Table Extension
In the context of SQL, table extension is used to create a new table with the same schema as an existing table in the database. In the context of data analytics platforms like Tableau, table extension allows you to create a table in a data source that can send data and a script to an analytics extension, returning a full table of results.
Table extensions can be used to store the result of complex queries temporarily in a new table. Table extensions in Tableau have the following benefits: easily integrate scripts or advanced functions, easily drag data from data connections as input into scripts, and refresh every time you open a workbook or refresh a data source.
Table extensions can be created using the SQL command CREATE TABLE newTable LIKE oldTable. Table extensions in Tableau can be created using the Tableau interface, defining relationships between fields in different tables, and writing custom scripts.

In summary, "table extension" and "table extention" seem to refer to different concepts depending on the context. In the context of SQL, table extension is used to create a new table with the same schema as an existing table, while in the context of data analytics platforms like Tableau, table extension allows you to create a table in a data source that can send data and a script to an analytics extension.