Why is my database using Partitioning? ( I know it's not )

Running this query:

select * from sys.dm_db_persisted_sku_features

Shows me that I'm using Partitioning:

| feature_name | feature_id |
|--------------|------------|
| Partitioning | 200        |

I'm pretty sure that I'm not using partitioning, since this database is only mine, and it's for consulting. There are 3 tables that I created using simple "create table" statements. There's no index on tables too. So, why is SQL Server saying that this database is using Partitioning?

According to this documentation, this will return a value if the database has any of the following:

• Partitioned tables

• Partitioned indexes

• Partition schemes

• Partition functions

So check for and remove any partition schemes or functions, even if they aren't in use. You can do this in the SSMS UI (Database > Storage > Partition Schemes/Functions), or by querying the following system views:

• sys.partition_schemes

• sys.partition_functions

StackExchange Database Administrators Q#200002, answer score: 9