Interested to Buy Any Domain ? << Click Here >> for more details...
Situation: you need a create a table with fields without referring to data elements. Is it possible? If yes, how?
- 1 Answers
- 2 Views
- I also Faced
- E-Mail Answers
Answer Posted / Amrit Kumar
Yes, it is possible to create a table in SAP MaxDB without referring to data elements. This can be achieved using the CREATE TABLE AS SELECT (CTAS) statement:nnCREATE TABLE new_table AS SELECT column1, column2... FROM old_table;nThis creates a new table with the same structure as the old table. The column names are automatically assigned based on the selected columns from the old table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
