sqlserver 注释查看
点位 | SQL |
---|---|
创建表 | 创建表 |
表结构和单表相关信息 | sp_help ‘TABLE_NAME’ |
字段变长 | alter table gggs.dbo.stu1 alter COLUMN st_na varchar(30) |
系统时间 | getdate() |
表注释查看 | 增加表和行注释 |
表注释查看 | 表注释查看 |
行注释查看 | 行注释查看 |
update | update |
表注释查看
SELECT so.[id] AS ObjectID,
so.[name] AS ObjectName, so.XType,
(CASE WHEN (LEFT(text, 2) = '/*')
AND (charindex('*/', text) > 0) THEN substring([text], 3, patindex('%*/%', text) - 3)
ELSE '' END) AS Comments
FROM syscomments AS sc full join