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

忘是亡心i 2021-12-24 01:47 451阅读 0赞

转自： [https://blog.csdn.net/qq\_23833037/article/details/54917610][https_blog.csdn.net_qq_23833037_article_details_54917610]

SQLServer 查询所有表名 + 查询表结构:  [https://blog.csdn.net/zengcong2013/article/details/36174741][https_blog.csdn.net_zengcong2013_article_details_36174741]

sql server 查询数据库所有的表名+字段: [https://blog.csdn.net/anxin997483092/article/details/78468081][https_blog.csdn.net_anxin997483092_article_details_78468081]

KETTLE整库迁移方案（SQL server迁移至Mysql，迁移过程自动创建表结构）: [https://blog.csdn.net/m0\_37213323/article/details/72538816][https_blog.csdn.net_m0_37213323_article_details_72538816]

用Kettle的一套流程完成对整个数据库迁移:  [https://blog.csdn.net/maenlai0086/article/details/80829143][https_blog.csdn.net_maenlai0086_article_details_80829143]

KETTLE整库迁移方案（SQL server迁移至Mysql，迁移过程自动创建表结构）:  [https://blog.csdn.net/m0\_37213323/article/details/72538816][https_blog.csdn.net_m0_37213323_article_details_72538816]

kettle入门(六) 之kettle抽取变量表名表:  [https://blog.csdn.net/xiaohai798/article/details/45367617?utm\_source=blogxgwz9][https_blog.csdn.net_xiaohai798_article_details_45367617_utm_source_blogxgwz9]

kettle 批量抽取多个表数据:  [https://blog.csdn.net/qq\_35318838/article/details/53322530][https_blog.csdn.net_qq_35318838_article_details_53322530]

kettle 通过表名批量同步: [https://blog.csdn.net/xufan601391682/article/details/78732025][https_blog.csdn.net_xufan601391682_article_details_78732025]

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.csdn.net/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  
\---------------------   
作者：秋风十里   
来源：CSDN   
原文：https://blog.csdn.net/qq\_23833037/article/details/54917610   
版权声明：本文为博主原创文章，转载请附上博文链接！

[https_blog.csdn.net_qq_23833037_article_details_54917610]: https://blog.csdn.net/qq_23833037/article/details/54917610
[https_blog.csdn.net_zengcong2013_article_details_36174741]: https://blog.csdn.net/zengcong2013/article/details/36174741
[https_blog.csdn.net_anxin997483092_article_details_78468081]: https://blog.csdn.net/anxin997483092/article/details/78468081
[https_blog.csdn.net_m0_37213323_article_details_72538816]: https://blog.csdn.net/m0_37213323/article/details/72538816
[https_blog.csdn.net_maenlai0086_article_details_80829143]: https://blog.csdn.net/maenlai0086/article/details/80829143
[https_blog.csdn.net_xiaohai798_article_details_45367617_utm_source_blogxgwz9]: https://blog.csdn.net/xiaohai798/article/details/45367617?utm_source=blogxgwz9
[https_blog.csdn.net_qq_35318838_article_details_53322530]: https://blog.csdn.net/qq_35318838/article/details/53322530
[https_blog.csdn.net_xufan601391682_article_details_78732025]: https://blog.csdn.net/xufan601391682/article/details/78732025