Interested to Buy Any Domain ? << Click Here >> for more details...
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 / Ziyaul Rehman
Yes, it is possible to create a table in SAP MaxDB without referring to data elements by using the CREATE TABLE AS SELECT (CTAS) statement. With this statement, you can create a new table and populate it with data from an existing table or query, without needing to define the fields first. Here's an example:
CREATE TABLE NEW_TABLE AS SELECT FIELD1, FIELD2 FROM EXISTING_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
