VS2010数据库项目有表设计器吗? [英] Is there a table designer for VS2010 database project?
问题描述
我在这里错过了什么吗?似乎在VS2010中的数据库项目中创建新表的唯一选择是:
Am I missing something here? It seems that the only options to create a new table in a database project in VS2010 is:
将表对象创建为文件,然后将所有约束(默认值)创建为单独的文件,然后将每个索引创建为单独的文件,并将主键创建为单独的文件,并在其上...
Create a table object as a file, then create all constraints (defaults) as separate files, then create each index as a separate file, and primary key as a separate file and on and on...
或
使用SSMS中的表设计器创建整个表模式,然后使用模式比较工具为表的每个元素创建单个的SQL语句整体文件,并将每个代码块复制到VS中新创建的文件中.
Create the entire table schema using the table designer in SSMS and then use the schema compare tool to create a single monolithic file of SQL statements for each element of the table and copy each block of code to a newly created file in VS.
这个问题是2年前提出的,我希望答案已经改变. 请告诉我,我刚刚忽略了VS2010中数据库项目的隐藏表设计器.
This question was asked 2 years ago and I'm hoping the answer has changed. Please tell me there's a hidden table designer for the database project in VS2010 that I have just overlooked.
推荐答案
我很确定没有一个!
我可以问为什么在为新对象创建和修改创建脚本文件时,为什么需要表设计器?有什么不给您设计师所能提供的东西吗?
Can I ask why you need a table designer over creating and modifying creation script files for your new objects? Is there anything that this doesn't give you that a designer would?
这篇关于VS2010数据库项目有表设计器吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!