Answers

Question and Answer:

  Home  Sybase

⟩ Can I Run Any Transact-SQL Command on a Partitioned Table in Sybase?

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.

 146 views

More Questions for you: