Refresh Table from View

Convert SQL View into table for speed reading.
Using views a lot, I needed a quick way to convert that view into table to speed things up if we need that since view sometimes can be complicated. This is it.

CodeFunctionName
What is this?

Public

Not Tested

Original Work
-- AI generated version
-- Here is a possible code for creating a stored procedure that will delete the table tblView and then create it from the view vwView.

CREATE PROCEDURE spCreateTableFromView
AS
BEGIN
-- Check if the table exists
IF OBJECT_ID('tblView', 'U') IS NOT NULL
BEGIN
    -- Delete the table
    DROP TABLE tblView;
END

-- Create the table from the view
SELECT *
INTO tblView
FROM vwView;
END





-- Another version that CLEARS table, not drops it. Expects we know all columns of table and view
CREATE PROCEDURE MoveRowsFromViewToTable
AS
BEGIN
    Delete From table -- Where 1 = 1
    Go
    INSERT INTO table_name (column_list)
    SELECT column_list FROM view_name
    -- WHERE condition;
END
EXECUTE MoveRowsFromViewToTable

Views 79

Downloads 24

CodeID
DB ID