How to convert a SQL view into a table?

[YLM1603]

Can I convert a SQL view into a table to perform the necessary transformations without having to update the data?

[pankajnamekar25 · Accepted solution]

Hello @YLM1603 

try this

CREATE TABLE new_table AS

SELECT * FROM your_view;

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-tsaipranay]

Hi @YLM1603 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-tsaipranay]

Hi @YLM1603 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-tsaipranay]

Hi @YLM1603 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-tsaipranay]

Hi @YLM1603 

Thank you for reaching out to the Microsoft Fabric community forum. Also thank you @wokka  and @pankajnamekar25  for your inputs.

Also, could you confirm which SQL platform you're using (e.g., SQL Server, PostgreSQL, MySQL)? The syntax for converting a view into a table differs slightly depending on the system.

Thank you.

[wokka · Accepted solution]

In SQL Server using TSQL :

select *
into <new_table>
from <database>.<schema>.<view_name>

[pankajnamekar25 · Accepted solution]

Hello @YLM1603 

try this

CREATE TABLE new_table AS

SELECT * FROM your_view;

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.