SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE '' END AS 表名 ,CASE WHEN col.colorder=1 then isnull(epTwo.value,'') else '' end as 表说明,col.colorder AS 序号 ,col.name AS 列名 ,ISNULL(ep.[va...
SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE '' END AS 表名 ,CASE WHEN col.colorder=1 then isnull(epTwo.value,'') else '' end as 表说明,col.colorder AS 序号 ,col.name AS 列名 ,ISNULL(ep.[va...
mysql查看表结构命令
mysql查看表结构命令,如下:
desc 表名;show columns from 表名;describe 表名;show create table 表名;
use information_schemaselect * from columns where table_name='表名';
顺便记下:...
mysql查看表结构命令,如下:
desc 表名;
show columns from 表名;
describe 表名;
show create table 表名;
use information_schema
select * from columns where table_name='表名';
顺便记下:
show databases;...
快速查看表对的就说明,及表字段描述及字段类型
--表描述
SELECT tbs.name 表名,ds.value 描述
FROM sys.extended_properties ds
LEFT JOIN sysobjects tbs ON ds.major_id=tbs.id
WHERE ds.minor_id=0 and...
---收缩数据库日志文件
USE [master]ALTER DATABASE yourdatabasename SET RECOVERY SIMPLE WITH NO_WAITALTER DATABASE yourdatabasename SET RECOVERY SIMPLE USE yourdatabasename DBCC SHRINK...
SqlServer字段说明查询
SELECT t.[name] AS 表名,c.[name] AS 字段名,cast(ep.[value]
as varchar(100)) AS [字段说明]
FROM sys.tables AS t
INNER JOIN sys.columns
AS c ON t.object_id = c.object_id...
MySQL查看表结构SQL语句
=
mysql查看表结构命令,如下:
desc 表名;
show columns from 表名;
describe 表名;
show create table 表名;
use information_schema; #切换到information_schema数据库
select * from c...
${database} 为数据库的名称
/*1.查看索引
(1)单位是GB*/
SELECT CONCAT(ROUND(SUM(index_length)/(**), ), ' GB') AS 'Total Index Size'
FROM information_schema.TABLES WHERE table_schema LIKE '${dat...
--查看表空间的真实使用情况
set linesize 500 pagesize 500
col tablespace_name format a25
col tp_real_gb format a15
col tp_real_free_gb format a20
select all_tp.tp_name "tablespace_name",
to_...