ÓÃsql²é¿´±í½á¹¹
1.oracle
sql = "SELECT column_name, data_type, data_length, nullable";
sql += " from user_tab_columns ";
sql += " where table_name='";
sql += $tableName;
sql += "'";
select * from user_tab_comments ²éѯ±íÃû¼°±í˵Ã÷£¨comment)
select * from user_col_comments ²éѯ±í¼°±íÖÐ×ֶεÄ˵Ã÷
2.sql server
select name,xtype,length,isnullable from syscolumns
where id =(select top 1 Id from sysobjects where name = '±íÃû');
sql = "select name,xtype,length,isnullable from syscolumns where id =";
sql += " (select top 1 Id from sysobjects where name = '";
sql += $tableName;
sql += "')";
3.my sql
sql = "show columns from ";
sql += $tableName;
»ò
sql = "desc ";
sql += $tableName;
»ò
sql = "describe ";
sql += $tableName;
Ïà¹ØÎĵµ£º
http://www.cnblogs.com/Mainz/archive/2008/12/20/1358897.html
ʲôÇé¿öÏÂʹÓñí±äÁ¿£¿Ê²Ã´Çé¿öÏÂʹÓÃÁÙʱ±í£¿
±í±äÁ¿£º
DECLARE @tb table(id int identity(1,1), name varchar(100))
INSERT @tb
SELECT id, name
from mytable
WHERE name like ‘zhang%&rsquo ......
²éѯËÙ¶ÈÂýµÄÔÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
¡¡¡¡
¡¡¡¡1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
¡¡¡¡
¡¡¡¡2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
¡¡¡¡
¡¡¡¡3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
¡¡¡¡
¡¡¡¡4¡¢ÄÚ´æ²»×ã
¡¡¡¡
¡¡¡¡5¡¢ÍøÂçËÙ¶ÈÂý
¡¡¡¡
¡¡¡¡6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó£¨¿ÉÒÔ²ÉÓöഠ......
if object_id('[tb]') is not null
drop table [tb]
go
create table [tb]([id] int,[col1] varchar(8),[col2] int)
insert [tb]
select 1,'ºÓ±±Ê¡',0 union all
select 2,'ÐĮ̈ÊÐ',1 union all
select 3,'ʯ¼ÒׯÊÐ',1 union all
select 4,'ÕżҿÚÊÐ',1 union all
&n ......
5.1 ÃÜÂë²ßÂÔ
¡¡¡¡ÓÉÓÚsql server²»Äܸü¸ÄsaÓû§Ãû³Æ£¬Ò²²»ÄÜɾ³ýÕâ¸ö³¬¼¶Óû§£¬ËùÒÔ£¬ÎÒÃDZØÐë¶ÔÕâ¸öÕʺŽøÐÐ×îÇ¿µÄ±£»¤£¬µ±È»£¬°üÀ¨Ê¹ÓÃÒ»¸ö·Ç³£Ç¿×³µÄÃÜÂ룬×îºÃ²»ÒªÔÚÊý¾Ý¿âÓ¦ÓÃÖÐʹÓÃsaÕʺš£Ð½¨Á¢Ò»¸öÓµÓÐÓësaÒ»ÑùȨÏ޵ij¬¼¶Óû§À´¹ÜÀíÊý¾Ý¿â¡£Í¬Ê±Ñø³É¶¨ÆÚÐÞ¸ÄÃÜÂëµÄºÃÏ°¹ß¡£Êý¾Ý¿â¹ÜÀíÔ±Ó¦¸Ã¶¨Æڲ鿴ÊÇ·ñÓв»·ûºÏ ......