MySQL Bugs: #50034: Feature request: FOREIGN KEY and CONSTRAINT comments

Bug #50034	Feature request: FOREIGN KEY and CONSTRAINT comments
Submitted:	3 Jan 2010 9:44	Modified:	3 Jan 2010 10:48
Reporter:	Walter Stanish	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	comments, constraint, foreign key

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
It would be nice to be able to add comments against constraints and foreign keys.

This allows for increased documentation which can assist with the long term maintenance of complex databases.

How to repeat:
-- fails
ALTER TABLE sometable ADD CONSTRAINT unique(col1,col2,col3) COMMENT 'This will be extended in future ... some explanation ...';

Suggested fix:
Add constraint and foreign key COMMENT support, as per columns.

Thank you for the feature request.