Copy/Paste DDL From SQL Server Ent Mgr

Scott came across a cool trick to get DDL from SQL Server Ent Mgr (post here):

... from the Tables listing, hit Ctrl+C on a table name and then go to a text editor and hit Ctrl+V and get the appropriate CREATE TABLE SQL syntax for the “copied” table (which includes constraints)...

Gave it a whirl with the blog_Content table of the database that drives this blog, and it does indeed work correctly. DDL generated:

CREATE TABLE [blog_Content] (
[ID] [int] IDENTITY (145, 1) NOT NULL ,
[Title] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DateAdded] [smalldatetime] NOT NULL ,
[SourceUrl] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PostType] [int] NOT NULL ,
[Author] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SourceName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BlogID] [int] NULL ,
[Description] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DateUpdated] [smalldatetime] NULL CONSTRAINT [DF__blog_Cont__DateU__075714DC] DEFAULT (getdate()),
[TitleUrl] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Text] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ParentID] [int] NULL CONSTRAINT [DF__blog_Cont__Paren__0ABD916C] DEFAULT ((-1)),
[FeedBackCount] [int] NULL CONSTRAINT [DF__blog_Cont__FeedB__0BB1B5A5] DEFAULT (0),
[PostConfig] [int] NULL CONSTRAINT [DF__blog_Cont__PostC__44CA3770] DEFAULT (0),
[EntryName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

CONSTRAINT [PK_blog_Content] PRIMARY KEY CLUSTERED

(

[ID]

) WITH FILLFACTOR = 90 ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

Good find Scott!

No comments yet