I have table have 15 column and 35000 rows called inventory_transfers, what i need is to create a new table with the same structure as my original table but without data. how to do this in oracle database 11g
Question
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
To copy a table without copying its data, you can simply use this SQL statement:
But there is a limitation to using the above statement that you have to pay attention to:
The following database objects are not copied to the new version of your table
Or you can use another way to do this:
In the above statement, you will get the DDL statement of a specified table, and then you can easily change the table name, the indexes, etc.