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
