Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017Command partitioned run Table transact-sql

0

Posted

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

1 Answer

0

Posted

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.