-
Expert Member
Table structure copying
If we want to test a procedure involving calculations and updating data we are creating a duplicate file as
Create table xxx
as select * from tablename.
If any thing goes wrong we are droping the existing table and then renaming xxx as actual table.
But here the problem is while creating table xxx it is not copying base table constriants, triggers and indexes. How to copy a table along with its constraints , triggers and indexes?
-
Re: Table structure copying
When creating a new table by copying from an existing one it does not copy the constriants, triggers and indexes. You ned to maually define constriants, triggers and indexes.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules