Bat脚本备份sqlserver 表结构、存储过程、指定表数据：@echo off cd /d %~dp0 ::备份表结构、存储过程和部分配置表的数据 set LogFile=report.log set servername="192.168.43.9" set DBname="TEST" set User="sa" set Password="123456*"echo Deployed Time: %date% %time% >> %LogFile% echo Server Name: %servername% >> %LogFile% echo DB Name: %DBname% >> %LogFile%set zip7=C:\Program Files\7-Zip\7z.exe ::需要压缩的文...
SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE END AS 表名, col.colorder AS 序号 , col.name AS 列名 , ISNULL(ep.[value], ) AS 列说明 , t.name AS 数据类型 , col.length AS 长度 , ISNULL(COLUMNPROPERTY(col.id, col.name, Scale), 0) AS 小数位数 , CASE WHEN COLUMNPROPERTY(col.id, col.name, Is...
MYSQL和Oracle和SQLServer的查看表结构和创表语句： MYSQL: -- 查看表结构 desc t_login1; -- 查看创表语句 show create table t_login1; -- 查看索引结构 show index from t_login1; Oracle: -- 查看创表语句 select dbms_metadata.get_ddl(TABLE,T_LOGIN1) from dual; -- 查看表结构 select * from user_tables where table_name =upper(T_LOGIN1); -- 查看创建索引语句 select dbms_metadata.get_ddl(INDEX,STU_LOGIN) fro...
原文链接：http://www.cnblogs.com/xiaotiannet/p/3838150.htmlSQLServer 2005SELECTd.name NTableName,d.xtype NTableType,a.colorder NColumnIndex,a.name NColumnName,(case when COLUMNPROPERTY( a.id,a.name,IsIdentity)=1 then 1else 0 end) NIdnetityFG,(case when (SELECT count(*) FROM sysobjects WHERE (name in (SELECT name FROM sysindexes WHERE (id = a.id) AND (indid in (SELECT indid FROM sysindexkeys WHER...
--复制另一个数据库中的某张表的结构及数据--select * from Test.dbo.TestTable(查询表中所有数据) --into [表名] 插入当前数据库新表，如果没有该表就创建 select * into TestCopy from Test.dbo.TestTable --只复制表结构(1!=1等价于1<>1)--把查询出的数据插入到新表,如果没有数据就只是复制表结构了select * into TestCopy from Test.dbo.TestTable where 1!=1 --into #[表名] #代表临时表select * into #TestCopy from Test.d...
DECLARE @tablename VARCHAR(50) SET @tablename=表名--表描述 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 tbs.name=@tablename ORDER BY tbs.name--查看表结构 SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE END AS 表名, col.colorder AS 序号 , col.name AS 列名 , ISNULL(ep.[value], ) AS 列...
?--获取所有数据库名: SELECT name FROM master..sysdatabases WHERE name NOT IN ( master, model, msdb, tempdb, northwind,pubs )--获取某数据库的所有表： SELECT name FROM YiDianTongV2..sysobjects Where xtype=U ORDER BY name --获取所有表名 --XType=U:表示所有用户表; --XType=S:表示所有系统表;--获取某表所有字段名: SELECT * FROM syscolumns WHERE id=Object_Id(AdminsBase)--获取数据库所有类型 select name fro...
SqlServer字段说明查询及快速查看表结构 ?SqlServer字段说明查询SELECT t.[name] AS 表名,c.[name] AS 字段名,cast(ep.[value] as varchar(100)) AS [字段说明]FROM sys.tables AS tINNER JOIN sys.columns AS c ON t.object_id = c.object_idLEFT JOIN sys.extended_properties AS ep ON ep.major_id = c.object_id AND ep.minor_id = c.column_id WHERE ep.class =1 AND t.name=TableName快速查看表结构--快速查看表结构（比较全...