Sybase Question:
Download Questions PDF

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.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
How Does Partition Assignment Relate to Transactions in Sybase?How to view the log files in sybase?