Delete rows from CTE in SQL SERVER

Question

I have a CTE which is a select statement on a table. Now if I delete 1 row from the CTE, will it delete that row from my base table?

Also is it the same case if I have a temp table instead of CTE?

Answer 1

Checking the DELETE statement documentation, yes, you can use a CTE to delete from and it will affect the underlying table. Similarly for UPDATE statements...

Also is it the same case if I have a temp table instead of CTE?

No, deletion from a temp table will affect the temp table only -- there's no connection to the table(s) the data came from, a temp table is a stand alone object.