Copying table with identify column

Database
Highlighted
Enthusiast

Copying table with identify column

I'm trying to create an automated process that takes an empty copy of a table.

For example

 

Create Table1Copy AS Table1 with no data ;

 

This works fine but won't work with tables containing identity columns.

Is there a way to do this other than copying and pasting the table definition manually?