What does this query mean?

Question

I'm reading a book about SQL. In that book, I saw strange query below: ``` SELECT * into mycustomer from customer WHERE 1=2 ``` In this query, what is "WHERE 1=2" ?

Accepted Answer

Usually used to copy structure of one table to into another, as in your case.

```
SELECT * INTO mycustomer FROM customer WHERE 1=2
```

This code creates an identical structure of table `Customer` in your new table `MyCustomer`. Note that in SQL Server, the constraints are not copied; so probably you would need to recreate the constraints.

What does this query mean?

Solution

Problem