Find all tables containing column with specified name Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database. Search in all tables SELECT c.name AS 'Column', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name = 'MycolumnName' --specify search column name ORDER BY TableName,Column Search in all tables and views SELECT COLUMN_NAME AS 'Column', TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'MyColumnName' --specify search column name ORDER BY TableName,Column;

how long does variables stay in memory in Node.js

Rathnakar

I'm new to backend with nodejs. most recently on a project I chose to unzip the zip file received from API in memory to work with it. But now i think about whether this is resource-saving. I would therefore like to ask the experienced nodejs developers, how long does the zip file stored in memory actually stay in memory? As long as the server is running or until the function ends?

I used the Zip-Tool adm-zip.

code-snippet

function getJsonFiles () {
    const zipReportsFile = await fetch(this.generateApiUrl({action:"get",project:project.name,compression:"zip",date:myDate}));
    
    const zipReportsFileBuffer = Buffer.from(await zipReportsFile.arrayBuffer());
    
    //reading zip archive in memory
    const zipContent = new AdmZip(zipReportsFileBuffer);
                
    const jsonFiles = zipContent.getEntries();

    return jsonFiles;
}

every answer is appreciate.