通过代码查看sqlserver数据库所有表

最新推荐文章于 2024-08-26 03:14:11 发布

安静点DGC

最新推荐文章于 2024-08-26 03:14:11 发布

阅读量1.3k

点赞数

分类专栏： sqlserver c# 文章标签： sqlserver

本文链接：https://blog.csdn.net/qq_26925297/article/details/83210905

版权

c# 同时被 2 个专栏收录

42 篇文章 1 订阅

订阅专栏

sqlserver

1 篇文章 0 订阅

订阅专栏

           string connectionString = @"data source=服务器名;initial catalog=数据库名;persist security info=True;user id=登录名;password=密码;MultipleActiveResultSets=True";

           // string connectionString = @"Server=(local); Database=AdventureWorks; User ID=sa; Password=password";
           SqlConnection connection = new SqlConnection();
           connection.ConnectionString = connectionString;
           string sqlCommandString = @"USE MES_DT20180611 SELECT name FROM sys.sysobjects WHERE type='U' ORDER BY name";
           SqlCommand command = new SqlCommand();
           command.CommandType = System.Data.CommandType.Text;
           command.CommandText = sqlCommandString;
           command.Connection = connection;

           try
           {

               connection.Open();
           }
           catch (Exception e)
           {
               throw e;

           }

           SqlDataReader reader = command.ExecuteReader();
        //   string a = reader[@"name"];
           while (reader.Read())
           {
               Console.WriteLine(reader[@"name"]);
           }     从sqlserver中获取所有表名