Forum Discussion
YLM1603
1 year agoNew Member
How to convert a SQL view into a table?
Can I convert a SQL view into a table to perform the necessary transformations without having to update the data?
- 1 year ago
Hello YLM1603
try this
CREATE TABLE new_table AS
SELECT * FROM your_view;
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
- Anonymous1 year ago
In SQL Server using TSQL :
select *
into <new_table>
from <database>.<schema>.<view_name>
Anonymous
1 year agoNot applicable
In SQL Server using TSQL :
select *
into <new_table>
from <database>.<schema>.<view_name>