创建重复表及其约束 [英] Creating duplicate tables and it's constraints

问题描述

我需要创建一个重复的数据库及其表，通过读取
来约束
现有的数据库.我已经通过编程方式创建了数据库.但是我需要在
中创建表
特定的顺序.在我现有的数据库中，有很多相关的表.所以我需要

首先创建父表，然后创建子表.请帮助我.

在此先感谢您

Hi,

I need to create a duplicate database and it''s tables,constraints by reading from an

existing database.I have created database programically.But I need to create tables in a

particular order.In my existing database there are lot of related tables.So I need to

create parent table first then child table.Please help me.

Thanks in advance

推荐答案

您可以为所有这些简单地生成脚本.看看更多信息的链接:

You can simply generate scripts for all that. Have a look at the link for more info:
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

Good luck!

这篇关于创建重复表及其约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！