1.

Can I Run Any Transact­sql Command On A Partitioned Table In Sybase?

Answer»

No. Once you have partitioned a table, you cannot USE any of the following Transact­SQL commands on the table until you unpartition it:
1. drop table
2. sp_placeobject
3. TRUNCATE table
4. alter table table_name partition n 
On RELEASES of ASE prior to 11.5 it was not possible to create a clustered INDEX on a partitioned table either.

 

No. Once you have partitioned a table, you cannot use any of the following Transact­SQL commands on the table until you unpartition it:
1. drop table
2. sp_placeobject
3. truncate table
4. alter table table_name partition n 
On releases of ASE prior to 11.5 it was not possible to create a clustered index on a partitioned table either.

 


Discussion

No Comment Found

Related InterviewSolutions