Is it possible to create data extensions by running a query with the CREATE TABLE function?
No. Query Activities can only be
Here is what's supported:
The SQL support for the Query Activity is based on SQL Server 2005 capabilities.
Only SELECT statements to data extension or data views in an account or in the parent account
- Nested Queries
- GROUP BY
- IF Constructs
- CASE Statements
- Most functions (i.e. MIN, MAX, etc) are supported
- CAST and CONVERT
- User Defined Functions
- Transaction and Locking
- Any sp_* stored procedure
- Temporary Tables and Common Table Expressions
- TEXT and IMAGE Functions