sql查询某个数据库里所有表名及表信息

转自： https://blog.youkuaiyun.com/qq_23833037/article/details/54917610

SQLServer 查询所有表名 + 查询表结构:  https://blog.youkuaiyun.com/zengcong2013/article/details/36174741

sql server 查询数据库所有的表名+字段: https://blog.youkuaiyun.com/anxin997483092/article/details/78468081

KETTLE整库迁移方案（SQL server迁移至Mysql，迁移过程自动创建表结构）: https://blog.youkuaiyun.com/m0_37213323/article/details/72538816

用Kettle的一套流程完成对整个数据库迁移:  https://blog.youkuaiyun.com/maenlai0086/article/details/80829143

KETTLE整库迁移方案（SQL server迁移至Mysql，迁移过程自动创建表结构）:  https://blog.youkuaiyun.com/m0_37213323/article/details/72538816

kettle入门(六) 之kettle抽取变量表名表:  https://blog.youkuaiyun.com/xiaohai798/article/details/45367617?utm_source=blogxgwz9

kettle 批量抽取多个表数据:  https://blog.youkuaiyun.com/qq_35318838/article/details/53322530

kettle 通过表名批量同步: https://blog.youkuaiyun.com/xufan601391682/article/details/78732025

 

 版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.youkuaiyun.com/qq_23833037/article/details/54917610
sql server 数表: 
select count(1) from sysobjects where xtype=’U’

数视图: 
select count(1) from sysobjects where xtype=’V’

数存储过程 
select count(1) from sysobjects where xtype=’P’

所有表名 
SELECT * FROM INFORMATION_SCHEMA.TABLES

查询表的所有字段名： 
SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID(’ 表名’ )

SELECT * FROM INFORMATION_SCHEMA.TABLES

SELECT * FROM INFORMATION_SCHEMA.VIEWS

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
--------------------- 
作者：秋风十里 
来源：优快云 
原文：https://blog.youkuaiyun.com/qq_23833037/article/details/54917610 
版权声明：本文为博主原创文章，转载请附上博文链接！