通过MySQL和SQL Server上的查询生成表DDL?

DDL代表数据定义语言。要通过查询生成表DDL,可以使用show create命令。

语法如下

SHOW CREATE TABLE yourTableName;

上面的语法是MySQL特有的。假设我们有一个名为“ DDLOfTableStudent”的表。

首先,创建一个名称为“ DDLOfTableStudent”的表。创建表的查询如下

mysql> create table DDLOfTableStudent
   -> (
   -> StudentId int,
   -> StudentFirstName varchar(100),
   -> StudentLastName varchar(100),
   -> StudentAddress varchar(200),
   -> StudentAge int,
   -> StudentMarks int
   -> );

使用以上语法可以了解表的DDL。查询如下

mysql> SHOW CREATE TABLE DDLOfTableStudent;

以下是显示DDL的输出

+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table             | Create Table                                                                                                                                                                                                                                                                                                                                                   |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DDLOfTableStudent | CREATE TABLE `ddloftablestudent` (`StudentId` int(11) DEFAULT NULL,`StudentFirstName` varchar(100) DEFAULT NULL,`StudentLastName` varchar(100) DEFAULT NULL,`StudentAddress` varchar(200) DEFAULT NULL,`StudentAge` int(11) DEFAULT NULL,`StudentMarks` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)