SQE
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
add_commentary
Parameters
Name
Type
Mode
Definition
BEGIN DECLARE v_finished INTEGER DEFAULT 0; DECLARE v_table VARCHAR(100) DEFAULT ''; DECLARE stmt VARCHAR(500) DEFAULT ''; DECLARE column_cursor CURSOR FOR SELECT TABLE_NAME FROM `information_schema`.`tables` WHERE table_schema = 'SQE' AND table_name LIKE '%_owner'; DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1; OPEN column_cursor; alter_tables: LOOP FETCH column_cursor INTO v_table; IF v_finished = 1 THEN LEAVE alter_tables; END IF; SET @prepstmt = CONCAT('ALTER TABLE SQE','.',v_table,' ADD COLUMN commentary LONGTEXT;'); PREPARE stmt FROM @prepstmt; EXECUTE stmt; DEALLOCATE PREPARE stmt; END LOOP alter_tables; CLOSE column_cursor; END