How to get partitioning information of a table using SQLServerDatabaseMetaData API ?

342 Views Asked by At

I don't see relevant methods are available in that class.

P.S: This class is available in the jdbc jar provided by MS. (mssql-jdbc-6.2.1.jre8.jar)

1

There are 1 best solutions below

0
On

As we can see from the source code, SQLServerDatabaseMetaData.java (currently) makes no mention of partition information. To retrieve that information you will need to run a query against the sys.partitions catalog view (or similar).