- column_name
- A column or list of columns from source_table_name to be copied to target table table_name.
- column attributes
- One or more new column attributes for the column set specified by column_name to be used for the new definition for table_name. You cannot specify a foreign key constraint as a column attribute using the AS clause syntax.
- table constraints
- One or more new table constraints for the column set specified by column_name to be used for the new definition for table_name. You cannot specify a foreign key constraint as a table constraint using the AS clause syntax.
- database_name
- user_name
- The containing database or user for source_table_name if not the current database or user.
- source_table_name
- The name of the source table whose column- and table-level definitions (with some restrictions) and, optionally, data and statistics are to be copied to table_name.