没有主键的表可以争取多少行（microsoft sql server management studio 2008）？ [英] how many rows a table without a primary key can strore (microsoft sql server management studio 2008)?

问题描述

我有一张没有主键的表。它只存储200条记录，但我想存储更多？我怎样才能做到这一点？任何人都可以帮我吗？

解决方案

如果你没有表的主键，你不受限制（数字）。



执行：

 选择 count（*）来自 [yourtablename] 

查看表格中有多少条记录。

行数不限于200，也许您在SQL Management中看到了编辑前200行选项。



以下是 SQL Server的最大容量规范 [ ^ ]



所以你可以在上面的链接上看到每个表的行数是受可用存储限制！

如果你不能添加更多记录，我能想到的唯一原因是因为一个独特的索引或类似的东西。你当然可以存储比200更多的记录，所以听起来你还有别的东西。

i have a table which does not have a primary key. it stores only 200 records, but i want to store more than that? how can i do that? can any one help me with this?

解决方案

You are not limited (number wise) if you don't have a primary key for a table.

Do a :

select count(*) from [yourtablename]

to see how many records are in your table.

The numbers of rows is not limited to 200, maybe you saw in SQL Management the option: "Edit Top 200 Rows".

Here is the Maximum Capacity Specifications for SQL Server[^]

So as you can read on the link above the number of rows per table is "Limited by available storage"!

The only reason I can think of if you could not add more records is because of a unique index or something along those lines. You can certainly store many, many more records than 200 so it sounds like you have something else going on.

这篇关于没有主键的表可以争取多少行（microsoft sql server management studio 2008）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！