Error 4954

Severity

16

Message text

Cannot unpartition table '%.*s' because it is not partitioned.

Explanation

The partition clause of the alter table command allows you to partition user tables that do not have a clustered index. The unpartition clause of the alter table command allows you to concatenate all existing page chains for these tables. You cannot unpartition a table that is not partitioned.

Error 4954 occurs when you try to unpartition a table that is not partitioned.

Action

No action is required.

If you want to determine whether a table is partitioned, use the following commands:

1> use <database_name>
2> go
1> sp_help <table_name>
2> go

Additional information

Refer to the Reference Manual: Commands for information about the alter table command.

Versions in which this error is raised

All versions