mysql查询sqlserver表_[MySQL] mysql和sqlserver中查看当前库中所有表和字段信息

mysql 和 sqlserver 中查看当前库中所有表和字段信息

>>mysql :

1、查看所有表名：

show tables [from db_name];

2、查看字段信息

SHOW FULL COLUMNS FROM db_name.table_name

获取以下信息

Field ：字段名

Type：字段类型

Collation：字符集(mysql 5.0 以上有)

Null ：是否可以为 NULL

Key：索引(PRI,unique,index)

Default：缺省值

Extra：额外(是否 auto_increment)

Privileges：权限

Comment：备注(mysql 5.0 以上有)

1 mysql> create table teacher # 创建teacher表

2 -> (

3 -> Id int (5) auto\_increment not null primary key,

4 -> name char(10) not null,

5 -> address varchar(50) default 'No.1 Mid school',

6 -> year date

7 -> );

8 Query OK, 0 rows affected (0.02 sec)

10 mysql> show tables;

11 +------------------+

12 | Tables\_in\_school |

13 +------------------+

14 | teacher |

15 +------------------+

16 1 row in set (0.00 sec)

18 mysql> show full columns from teacher; # 显示teacher表的所有字段

19 +---------+-------------+-------------------+------+-----+-----------------+----------------+---------------------------------+---------+

20 | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |

21 +---------+-------------+-------------------+------+-----+-----------------+----------------+---------------------------------+---------+

22 | Id | int(5) | NULL | NO | PRI | NULL | auto\_increment | select,insert,update,references | |

23 | name | char(10) | latin1\_swedish\_ci | NO | | NULL | | select,insert,update,references | |

24 | address | varchar(50) | latin1\_swedish\_ci | YES | | No.1 Mid school | | select,insert,update,references | |

25 | year | date | NULL | YES | | NULL | | select,insert,update,references | |

26 +---------+-------------+-------------------+------+-----+-----------------+----------------+---------------------------------+---------+

27 4 rows in set (0.01 sec)

29 mysql> drop table teacher; # 删除teacher表

30 Query OK, 0 rows affected (0.03 sec)

32 mysql> show tables;

33 Empty set (0.00 sec)

35 mysql>

原文链接：https://www.cnblogs.com/Robotke1/archive/2013/04/24/3041372.html