Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krishnakumar
Starting Member
5 Posts |
 Posted - 2007-10-26 : 11:21:35
|
| Sir,I need your assitance again.Is it possible to do the partition on existing table?if yes can anybody advice me to do thatThank youKrishna kumar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-26 : 11:30:24
|
| Are you referring to partitioned views/tables? If so, then yes you can partition existing tables but you may need to rebuild them if they don't conform to the requirements of partitioning. See BOL for more details.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
krishnakumar
Starting Member
5 Posts |
Posted - 2007-10-26 : 11:46:42
|
| No! I dont have view. It is a physical table. I want to partion that table. Is there any need to change the schema..? Or i need to go to view..?Krishnakumar |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-26 : 12:11:17
|
| You are missing my point. There are two types of partitioning. Both occur on tables. Check BOL for what type of partitioning you want and what the requirements are.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 00:53:18
|
| If you want to partition table, have to defind partition function and schema first then recreate the table with partition schema. |
|
|
|
|
|
|
Partition