我可以从Tables中删除默认ID吗？ [英] Can I delete the default ID from Tables

问题描述

如何从表中删除默认Id，我可以创建另一个主键..

How Can I delete the default Id from Tables and Can I Make another Primary Key ..

还有什么方法可以编写类似于"Sql Quary"的Sql Quary。 select * from table"不使用过滤器

And is there any way to write an Sql Quary like " select * from table " without using Filters

thanx&最好的问候

thanx & best regards

推荐答案

目前无法删除"内在"的现有ID。在LS的B2中的表。另一种方法是在SQL Server（包括SQL Express）中创建一个外部数据库，并将其作为外部数据源附加。我们被告知下一个版本的
（如果我没记错的话，RTM）会给你一个GUID作为主键的选项。

There is currently no way to delete the existing id of an "intrinsic" table in B2 of LS. The alternative is to create an external database in SQL Server (including SQL Express) & attach it as an external data source. We've been told that the the next version (the RTM if I remember correctly) will give you the option to have a GUID as the primary key though.

V1也没有内置的执行SQL语句的方法，但如果您有Visual Studio Pro或更高版本，则可以创建自定义RIA服务。这并不像你想象的那么难，这是一篇很好的文章，

我如何：显示基于聚合数据的图表，来自微软的Eric Erhardt。不要担心这是创建聚合查询以在图表中显示，它表明创建RIA服务是多么容易。

V1 also has no built-in way of executing SQL statements, but if you have Visual Studio Pro, or higher, you could create a custom RIA service. It's not as hard as you may think, here's an excellent article, How Do I: Display a Chart Built on Aggregated Data,  from Microsoft's Eric Erhardt. Don't worry that this is creating an aggregate query for displaying in a chart, it demonstrates how easy it is to create a RIA service.

这篇关于我可以从Tables中删除默认ID吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！