CTAS with clustered index on SQL Server Is it possible to create a table with a clustered key from a query in a single step or do I have to do this:

select 1 as id into foo;
create unique clustered index pk_foo on foo(id)
You have to add the index in a separate step.

From MSDN:


  Indexes, constraints, and triggers defined in the source table are not
  transferred to the new table, nor can they be specified in the
  SELECT...INTO statement. If these objects are required, you must
  create them after executing the SELECT...INTO statement.