modify a table scheme [modified]

[genieabdo]

hi i'm lookin for changing a scheme of my table who can i do it I already have a table with 20,000 record I created a new partition with a new shceme I want applied to my table thanks

modified on Tuesday, October 12, 2010 10:26 AM

[Blue_Boy]

Use ALTER TABLE[^]

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[genieabdo]

i did'n fing a alter table for changing scheme the partition of table

[Gerben Jongerius]

You can't, that is to say you could create a new instance in the schema and then populate it. But you won't copy keys, indexes or constraints. The query below would do that.

insert into newscheme.dbo.mytable
select * from oldscheme.dbo.mytable

[genieabdo]

I already have a table with 20,000 record I created a new partition with a new shceme I want applied to my table

[Bernhard Hiller]

Please try to add some further information, perhaps we can understand then what you are trying to do. Which database do you use - Oracle? What is that "partition" - a partition of your hard disk, a "table space", ...? What is the "scheme" - is that the wording used by Oracle? And finally, what do you mean with "applied to my table"? Do you want to copy/move your table to that scheme?