---
title: "How many columns maximum can be created in a table of a inner table of the subquery?"  
description: "How many columns maximum can be created in a table of a inner table of the subquery?"  
author: "Chris Anderson"  
published: 2011-09-17  
updated: 2020-09-22  
canonical: https://www.mindstick.com/interview/1268/how-many-columns-maximum-can-be-created-in-a-table-of-a-inner-table-of-the-subquery  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# How many columns maximum can be created in a table of a inner table of the subquery?

Maximum number of columns in a table --> 256 \
Maximum lenght of a row in a table -- > 64KB

## Answers

### Answer by Chris Anderson

Maximum number of columns in a table --> 256 \
Maximum lenght of a row in a table -- > 64KB


---

Original Source: https://www.mindstick.com/interview/1268/how-many-columns-maximum-can-be-created-in-a-table-of-a-inner-table-of-the-subquery

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.