数据库常用查询sql语句

1.查询用户自建的表约束

SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint, --约束名
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName, --表名
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT'
and OBJECT_NAME(OBJECT_ID) like 'SYS_ACTION_OPERATE_LOG%' --约束名

2. 查询MOM_PRD_ZENNER 库中有多少张表

select count(1) from sysobjects where xtype='U'