请设计一个存储过程，要求输入表名，输出这张表的建表语句和创建约束的语句

根据不同的数据库管理系统，存储过程的语法可能会有所不同。以下是一个示例MySQL存储过程，用于获取指定表的建表语句和创建约束的语句：

DELIMITER //

CREATE PROCEDURE `get_table_ddl`(IN `table_name` VARCHAR(255))
BEGIN
DECLARE `ddl` VARCHAR(10000) DEFAULT ''; -- 用于存储建表语句
DECLARE `constraint_ddl` VARCHAR(10000) DEFAULT ''; -- 用于存储约束语句
DECLARE `column_name` VARCHAR(255); -- 用于存储列名
DECLARE `data_type` VARCHAR(255); -- 用于存储数据类型
DECLARE `is_nullable` VARCHAR(255); -- 用于存储是否可为空
DECLARE `character_set` VARCHAR(255); -- 用于存储字符集
DECLARE `collation` VARCHAR(255); -- 用于存储排序规则
DECLARE `column_default` VARCHAR(255); -- 用于存储默认值
DECLARE `column_key` VARCHAR(255); -- 用于存储键类型
DECLARE `extra` VARCHAR(255); -- 用于存储附加信息

SELECT `table_schema`, `table_name`, `table_type`
INTO @schema, @table_name, @table_type
FROM `information_schema`.`tables`
WHERE `table_name` = `table_name` LIMIT 1;

-- 检查表是否存在
IF @table_name IS NULL THEN
SELECT 'Table not found.' AS `Error`;
LEAVE `get_table_ddl`;
END IF;

-- 获取表的基本信息
SET `ddl` = CONCAT(`ddl`, 'CREATE ', @table_type, ' `', @schema, '`.`', @table_name, '` (\n');

-- 获取列信息
DECLARE `columns_cursor` CURSOR FOR
SELECT `column_name`, `data_type`, `is_nullable`, `character_set_name`,
`collation_name`, `column_default`, `column_key`, `extra`
FROM `information_schema`.`columns`
WHERE `table_schema` = `schema`
AND `table_name` = `table_name`
ORDER BY `ordinal_position`;

OPEN `columns_cursor`;
SET `done` = 0;

columns_loop: LOOP
FETCH `columns_cursor` INTO `column_name`, `data_type`, `is_nullable`,
`character_set`, `collation`, `column_default`,
`column_key`, `extra`;

IF `done` THEN
LEAVE `columns_loop`;
END IF;

SET `ddl` = CONCAT(`ddl`, ' `', `column_name`, '` ', `data_type`);

-- 添加列的默认值
IF `column_default` IS NOT NULL THEN
SET `ddl` = CONCAT(`ddl`, ' DEFAULT ', `column_default`);
END IF;

-- 添加列是否可为空
IF `is_nullable` = 'NO' THEN
SET `ddl` = CONCAT(`ddl`, ' NOT NULL');
END IF;

IF `extra` = 'auto_increment' THEN
SET `ddl` = CONCAT(`ddl`, ' AUTO_INCREMENT');
END IF;

-- 添加排序规则和字符集
IF `collation` IS NOT NULL THEN
SET `ddl` = CONCAT(`ddl`, ' COLLATE ', `collation`);
END IF;

IF `character_set` IS NOT NULL THEN
SET `ddl` = CONCAT(`ddl`, ' CHARACTER SET ', `character_set`);
END IF;

SET `ddl` = CONCAT(`ddl`, ',\n');

-- 添加主键、唯一键、外键等约束
IF `column_key` = 'PRI' THEN
SET `constraint_ddl` = CONCAT(`constraint_ddl`, 'ALTER TABLE `', @schema, '`.`', @table_name, '` ADD PRIMARY KEY (`', `column_name`, '`);\n');
ELSEIF `column_key` = 'UNI' THEN
SET `constraint_ddl` = CONCAT(`constraint_ddl`, 'ALTER TABLE `', @schema, '`.`', @table_name, '` ADD UNIQUE KEY `', `column_name`, '` (`', `column_name`, '`);\n');
ELSEIF `column_key` = 'MUL' THEN
SET `constraint_ddl` = CONCAT(`constraint_ddl`, 'ALTER TABLE `', @schema, '`.`', @table_name, '` ADD FOREIGN KEY (`', `column_name`, '`) REFERENCES `', `referenced_table_schema`, '`.`', `referenced_table_name`, '` (`', `referenced_column_name`, '`);\n');
END IF;

END LOOP columns_loop;

CLOSE `columns_cursor`;

-- 去掉最后一个逗号
SET `ddl` = SUBSTR(`ddl`, 1, LENGTH(`ddl`) - 2);

SET `ddl` = CONCAT(`ddl`, '\n);\n');

-- 添加约束语句
SET `ddl` = CONCAT(`ddl`, `constraint_ddl`);

SELECT `ddl`; -- 输出建表语句和约束语句
END//

DELIMITER ;

使用方法：执行以下语句，然后调用存储过程并传入表名即可获取建表语句和约束语句。

CALL `get_table_ddl`('table_name');