How can we create a new table in SQL with only the structure?

Here is the query to do that.

Select * Into<B>From<A>Where1 = 2

Points to be noted:

• A is the source table.
• B is the destination table.
• The condition 1=2 is to prevent the data from being copyied.