最大列号数据库表中的最大行数和不同类型的数据库. [英] Max column no. and maximum rows in a database table indifferent types of database.

问题描述

This question may be repeated.
How much no of columns can we defined in a database table in different type of database like sql erver, ms access, my sql and so on.

Is there any limits of defining columns in any database table and limits of inserting rows in a table.

推荐答案

我怀疑这是家庭作业，但无论如何都不能完全正确地回答它，因为无论如何它还是取决于版本:
对于2008年之前的SQL Server，它被限制为1024，之后又引入了Wide Tables，将它增加到30000列.

我建议您最好的方法是从Google开始-这并不是一个困难的研究项目！

I suspect this is homework, but it can''t be answered too exactly anyway, as it depends on the version in many cases anyway:
For SQL server prior to 2008, it was limited to 1024, after that Wide Tables were introduced which increased it to 30000 columns.

I suggest that your best approach would be to start with Google - it''s not exactly a difficult research project!

http://stackoverflow.com/questions/759244/sql-server-the-maximum-number-of-rows-in-table [ ^ ]

http://stackoverflow.com/Questions/331323/how-many-columns-are-too-many-for-a-sql-server-2005-table [ http://stackoverflow.com/questions/858960/what- are-the-table-and-column-limits-in-sql [

http://stackoverflow.com/questions/759244/sql-server-the-maximum-number-of-rows-in-table[^]

http://stackoverflow.com/questions/331323/how-many-columns-are-too-many-for-a-sql-server-2005-table[^]
http://stackoverflow.com/questions/858960/what-are-the-table-and-column-limits-in-sql[^]

这篇关于最大列号数据库表中的最大行数和不同类型的数据库.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！