YB亚博APP首页

查询包含指定字段的悉数表

select distinct Column_Name,Table_name from information_schema.columns where Column_Name='CompanyCD2'

数据库名

select name from sysdatabases

表名

select name,id from sysobjects where xtype='U'

胪列列名

核心性能方面，小米12 Pro和一加10 Pro都是骁龙8三件套，性能方面两者都差不多，一加10 Pro散热面积高达34119平方毫米，而且在性能调度上偏保守，但是在玩游戏的时候两款手机都热。

declare @objid int,@objname char(40)

set @objname = '表名'

select @objid = id from sysobjects where id = object_id

(@objname)

select 'Column_name' = name from syscolumns where id =

@objid

order by colid

sql 查询所很是据库、表名、表字段追思

1、查询悉数表

select [id], [name] from [sysobjects] where [type] = 'u' order by [name]

2、查询所很是据库

3、select [name] from [sysdatabases] order by [name]

查询表中字段

select [name] from [syscolumns] where [name] = 'tableXXX'order by [colid]

SQL Server 查询悉数表的纪录数

SELECT object_name (i.id) TableName,

rows as RowCnt

FROM sysindexes i

INNER JOIN sysObjects o

ON (o.id = i.id AND o.xType = 'U ')

WHERE indid

ORDER BY TableName

sql若何巡逻表中的主键 和主键列

select a.name 表名,a.name 主键名, c.name 列名 from sys.key_constraints a

left join sys.index_columns b on a.parent_object_id=b.object_id

left join sys.columns c on b.object_id=c.object_id and b.column_id=c.column_id

left join sysobjects d on a.parent_object_id=d.id where b.index_id=1YB亚博APP首页