A Pivot term is used in the database for Pivot table which is used as data processing tool used to query, organize and summarize data or information between spreadsheets, tables or databases. In the Pivot table Dragging and dropping fields are facilitates rotational or pivotal, structural changes. Generic Pivot table term is used by many companies and software vendors. It is Microsoft branded and trademarked version which is mostly used in most Excel products. A Pivot table is especially useful with large amounts of data. figures to find the information. A Pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. In database lingo the Pivot table to turn the data slice and dice view.