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'