简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

如何判断一个表是否建立索引约束等信息的SQL语句_MySQL

WBOY
Release： 2016-06-01 13:48:57
Original
1191 people have browsed it

bitsCN.com

 

--获取某表的所有索引，包括索引归属列名
sp_statistics 'Table'
--获取索引与索引归属列以及描述信息
sp_helpindex 'Table'
--获取某表的约束信息以及归属列
sp_helpconstraint 'Table'
--获取某表中的自动增长列的列名
select    name   from    syscolumns   
  where    id=object_id('Table')   and    status   &   128   =   128
--获取某表中的自动增长列的列名
select    name   from    syscolumns   
  where    id=object_id('Table')   and     
                COLUMNPROPERTY(id,name,'IsIdentity')=1

bitsCN.com
Related labels：
how surface
source：php.cn
Previous article：MySQL存储过程问题_MySQL Next article：[转]由浅入深探究mysql索引结构原理、性能分析与优化_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！