Shulou(Shulou.com)05/31 Report--

How to get the code of SQL database information, in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

The code is as follows: SELECT Name FROM Master..SysDatabases ORDER BY Name-- get all database SELECT Name FROM [database name].. SysObjects Where XType='U' ORDER BY Name-- get all the tables under the database select name from syscolumns where id=object_id (N' table names')-- get all the fields in the table

-- get table field name, type, increment, description

The code is as follows: select syscolumns.name as field, whether syscolumns.isnullable as can be empty, systypes.name as SQL type, ISNULL (sys.identity_columns.is_identity,0) as increment, ISNULL (sys.extended_properties.value) '') as description from sysobjects join syscolumns on sysobjects.id = syscolumns.id join systypes on syscolumns.xusertype = systypes.xusertype left join sys.identity_columns on sys.identity_columns.object_id = syscolumns.id and sys.identity_columns.column_id = syscolumns.colid left join sys.extended_properties on sys.extended_properties.major_id = syscolumns.id and sys.extended_properties.minor_id = syscolumns.colid where sysobjects.name = 'table name'

This is the answer to the code question about how to get the SQL database information. I hope the above content can be of some help to you. If you still have a lot of doubts to solve, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.