SQLserver查询数据库所有字段-表名

2024-07-15 13:51:00

https://www.cnblogs.com/OliverQin/p/5913163.html

SELECT * FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME='Account'

SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.VIEWS
SELECT * FROM INFORMATION_SCHEMA.COLUMNS


SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID(' 表名' )

kk Blog —— 通用基础

date [-d @int|str] [+%s|"+%F %T"]
netstat -ltunp
sar -n DEV 1

SQLserver查询数据库所有字段-表名