Supported SQL dialects?

Which variations of the SQL dialect are supported when using the option under More in Create Schema ?

I’ve copied + pasted a simple CREATE TABLE statement from SQL Server (T-SQL) and get an error message. Unfortunately the message isn’t descriptive enough to tell me which column it doesn’t like :-/

Which versions of SQL could I try using?