TSD3007: Invalid supporting statement for {identifier}: {text}

This error occurs when an object definition contains a statement that is not valid for supporting statements. (For example, extended properties are valid supporting statements.)

To correct this error

• Remove the invalid statement from the object definition, and save the modified definition.

Example

This error appears if you have a statement or a partial statement that appears after the object definition and that is not a valid supporting statement. An extended property is an example of a valid supporting property.

CREATE TABLE t1(c1 int); goaddextendedproperty N'Description', N'Primary Key for t1','SCHEMA',N'dbo','TABLE', N't1', 'COLUMN', N'c1'

To correct this example, modify the extra statement to match the following:

EXEC sp_ addextendedproperty N'Description', N'Primary Key for t1','SCHEMA',N'dbo','TABLE', N't1', 'COLUMN', N'c1'

See Also

Tasks

How to: Modify Database Objects