一些常用的SQL

根据字段名定位到表名

SELECT
    TABLE_SCHEMA,
    TABLE_NAME,
    COLUMN_NAME,
    DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE UPPER(COLUMN_NAME) IN (
    '字段名1',
    '字段名2',
    '字段名3',
    '字段名4',
    '字段名5'
)
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;

　　查字段长度

SELECT
    c.name,
    TYPE_NAME(c.user_type_id) AS 数据类型,
    c.max_length              AS 字节长度,   -- 4000 就是 nvarchar(2000)
    c.max_length / 2          AS 字符长度,   -- 2000
    c.is_nullable,                           -- 1 表示允许 NULL
    c.collation_name
FROM sys.columns c
WHERE c.object_id = OBJECT_ID('dbo.表名')
  AND c.name = '字段名';

　查最近操作记录

SELECT TOP 100 * FROM dbo.T_BAS_OPERATELOG ORDER BY FDATETIME DESC