1

Is it possible to create data extensions by running a query with the CREATE TABLE function?

3

No. Query Activities can only be Select statements.

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
  • UNION
  • JOIN
  • GROUP BY

Conditional Statements

  • IF Constructs
  • CASE Statements

Functions

  • Most functions (i.e. MIN, MAX, etc) are supported
  • CAST and CONVERT

Unsupported elements

  • Variables
  • Cursors
  • User Defined Functions
  • Transaction and Locking
  • GOTO
  • PRINT
  • Any sp_* stored procedure
  • EXEC
  • Temporary Tables and Common Table Expressions
  • TEXT and IMAGE Functions

Reference

  • 2
    This isnt the first time you have come to the rescue @Adam Spriggs. Thanks – Samuel Dare Oct 3 '16 at 14:14

Not the answer you're looking for? Browse other questions tagged or ask your own question.