Below is the DDL for my tables.

USE [MSIU]

GO

/****** Object: Table [dbo].[tbl_DISTRIBUTOR_MASTER] Script Date: 3/28/2013 7:23:14 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tbl_DISTRIBUTOR_MASTER](

[int_DISTRIBUTOR_ID] [bigint]...

How do I generate the DDL for entire my Database?

Thanks for the responses.

I think what I need is a tutorial which will teach me on how to join multiple table.

Most of the tutorials I am getting on the internet do not show...

Hi,

I actually get duplicates when I run my query.

Hi All,

Thank you both for your responses. My query has a lot of wording because I was dragging the table names from the database tables in SQL Management Studio....