sql常用语句

mysql

• 查看表结构

SELECT
	COLUMN_NAME 列名,
	COLUMN_COMMENT 备注,
	DATA_TYPE 字段类型,
	COLUMN_TYPE 数据类型,
	IS_NULLABLE 是否为空,
	COLUMN_DEFAULT 默认值 
FROM
	information_schema.COLUMNS 
WHERE
	TABLE_NAME = '表名' 
	AND TABLE_SCHEMA = '库名' 
ORDER BY
	ordinal_position

sqlserver

• 查看表结构

SELECT CAST
( B.name AS VARCHAR ( 500 ) ) AS column_name,
D.data_type,
CAST ( C.value AS VARCHAR ( 500 ) ) AS column_comment 
FROM
	sys.tables A
	INNER JOIN sys.columns B ON B.object_id = A.object_id
	LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id 
	AND C.minor_id = B.column_id
	JOIN information_schema.columns D ON D.column_name= B.name 
	AND D.table_name= A.name 
WHERE
	A.name = '表名' 
ORDER BY
	B.column_id;

• mysql实现开窗函数
  https://www.cnblogs.com/gered/p/10430829.html#_label0_1