Error when documenting a particular table

bgsissonbgsisson Posts: 8
edited July 25, 2014 5:50AM in SQL Doc
I get the following error when documenting a database unless I deselect a particular table. This happens in multiple SQL instances for the same table.

Preview cannot be displayed
An exception has occurred while trying to display the preview. The error message is:
unexpected token: [";",<673>,line=23,col=2] [char=884]

Serious error? Send report.


The the table creation script generated from SSMS follows.

Any help you could offer would be greatly appreciated.

USE [xxxx]
GO

/****** Object: Table [dbo].[content_stream_owner] Script Date: 7/23/2014 8:44:10 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[content_stream_owner](
[content_stream_owner_id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[mall_id] [int] NULL,
[base_tenant_id] [int] NULL,
[tenant_id] [int] NULL,
[content_stream_data_id] [int] NOT NULL,
CONSTRAINT [pk_content_stream_owner] PRIMARY KEY CLUSTERED
(
[content_stream_owner_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->base_tenant] FOREIGN KEY([base_tenant_id])
REFERENCES [dbo].[BASE_TENANT] ([BASE_TENANT_ID])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->base_tenant]
GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->content_stream_data] FOREIGN KEY([content_stream_data_id])
REFERENCES [dbo].[content_stream_data] ([content_stream_data_id])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->content_stream_data]
GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->mall] FOREIGN KEY([mall_id])
REFERENCES [dbo].[MALL] ([MALL_ID])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->mall]
GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->tenant] FOREIGN KEY([tenant_id])
REFERENCES [dbo].[TENANT] ([TENANT_ID])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->tenant]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The primary key column for the table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'content_stream_owner_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The optional mall ID of the owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'mall_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The optional base tenant ID of the owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'base_tenant_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The optional tenant ID of the owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'tenant_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The idea of the content stream data row owned by this owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'content_stream_data_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The primary key of the table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'pk_content_stream_owner'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This is a foreign key into the base tenant table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'fk_content_stream_owner->base_tenant'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'As a foreign key into the mall table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'fk_content_stream_owner->mall'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This is a foreign key into the tenant table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'fk_content_stream_owner->tenant'
GO

Comments

Sign In or Register to comment.