DBA > Job Interview Questions > Sybase Interview Questions and Answers

Can I Run Any Transact-SQL Command on a Partitio

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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.

(Continued on next question...)

Other Job Interview Questions