数据库模式查找器 [英] Database schema finder

问题描述

大家好，
我有一个部署在SQL Server 2008中的数据库，它有大约20000个表.我想知道它的架构，但是找不到它.他们吗? .它可能会要求您安装图表支持，但会为您完成此操作.从图设计器中，您可以添加表.我通常通过首先添加一个图并将其用作可视设计器来启动新的数据库.如果您真正拥有大约2万张表，那么我不能保证性能可以远程使用.

如果需要的话，请不要清除想要您的数据库架构，您可以从生成脚本中获取它.


这是获取数据库架构的步骤.

#1:-在数据库"上单击鼠标右键，然后单击打开".
   A:-任务>生成脚本.
     使用向导单击下一步，直到 SET脚本选项

  B:-然后单击高级按钮，设置所有属性，例如具有触发器，索引，FK，唯一键等的架构.

Hello everyone ,
I have a database deployed in SQL server 2008 and it has like 20000 tables.I want to know its schema but I can''t find it.Is there any softwqre that is able to find and put all the tables and the relation ships between them ?

解决方案

If by schema you mean a diagram representing the db structure you can navigate to your db in SSMS, right click on the Database Diagrams folder and add new diagram. It may ask you to install diagram support but will do this for you. From the diagram designer you can add the tables. I usually start a new db by first adding a diagram and using it as a visual designer. If you genuinely have in the region of 20k tables, I can''t guarantee that the performance will be remotely usable.

Not Clear what you want if want your data base schema you can get it from the generate the script.


Here is the steps to get the data base schema.

#1:- Right Click on the DataBase and On.
   A:-   TASKS>>Generate Scripts..
     Using the Wizard click next untill SET Scripting Options         

  B:- Then Click on the Advance  Button on set all the properties like schema with trigger,indexes,FK,Unique Key etc..

这篇关于数据库模式查找器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！