Why create table as select statement is not working

[#1]

Hi All,

I have table in S4 schema and i need to create another table in custom schema. I just wrote a simple SQL statement in SQL Console Create Table <TableName> as Select * from S4.<Tablename>. It's getting failed.

I tried in all methods what we can use in SQL but it's getting failed. I'm not sure what i'm missing in conceptual.

[former_member773277]

Thanks Witalij,

Last night i tried below statement and it worked. Thanks for your inputs.

create column table "<TargetSchemaName>"."TEMP_DOCA" as (

select * from "<SourceSchemaName>"."DOCA" where GJAHR = '2021' and month(werks) <> '12')with data; -- with no data

with no data : it will create only structure