sp_getDDL returns the complete CREATE TABLE command in TSQL; I've been using it in a DDL audit trigger, and also using it more often then sp_help.

Could some of you folks please test drive my contribution a bit? a extrapair of eyes would help flesh out any mistakes or sections that need improvement.

I updated this procedure so that it additionally returns extended properties about the table in question.

here's some sample output:

CREATE TABLE [dbo].[TBSTATE] (

[STATETBLKEY] INT NOT NULL,

[INDEXTBLKEY] INT NOT NULL,

[STATECODE] CHAR(2) NOT NULL,

[STATENAME] VARCHAR(50) NOT NULL,

[FIPS] CHAR(2) NULL,

CONSTRAINT [PK__TBSTATE__17A421EC] PRIMARY KEY CLUSTERED (STATETBLKEY),

CONSTRAINT [STATECODEUNIQUE] UNIQUE NONCLUSTERED (STATECODE))

GO

EXEC sys.sp_addextendedproperty

@name = N'FIPS', @value = N'the FIPS code is a two digit numeric-only varchar with preceeding zeros assigned by the government',

@level0type = N'SCHEMA', @level0name = [dbo],

@level1type = N'TABLE', @level1name = [TBSTATE];