Yes, some SQL languages support it, some don't. Most SQL languages have something similar and they work in a similar way where some of the schema is copied, while some is not (like defaults). In this example, I use a specific SQL platform, SQL Server, to demonstrate this, but it would vary by SQL tool.
RE: SQL Basics: When To Use SELECT * INTO