SQL»ñÈ¡ËùÓÐÊý¾Ý¿âÃû¡¢±íÃû¡¢´¢´æ¹ý³ÌÒÔ¼°²ÎÊýÁбí

SQL»ñÈ¡ËùÓÐÊý¾Ý¿âÃû¡¢±íÃû¡¢´¢´æ¹ý³ÌÒÔ¼°²ÎÊýÁбí
1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
   (1)¡¢Select Name from Master..SysDatabases order by Name
2.»ñÈ¡ËùÓбíÃû:
   (1)¡¢Select Name from SysObjects Where XType=''U'' orDER BY Name
           XType=''U'':±íʾËùÓÐÓû§±í;
           XType=''S'':±íʾËùÓÐϵͳ±í;
   (2)¡¢SELECT name from sysobjects WHERE type = ''U'' AND sysstat = ''83''
           ×¢Ò⣺һ°ãÇé¿öÖ»ÐèÒªtype = ''U''£¬µ«ÓÐʱºò»áÓÐϵͳ±í»ìÔÚÆäÖУ¨²»ÖªµÀʲôԭÒò£©£¬¼ÓÉϺóÃæÒ»¾äºó¾ÍÄÜɾ³ýÕâЩϵͳ±íÁË
3.»ñÈ¡ËùÓÐ×Ö¶ÎÃû:
(1)¡¢Select Name from SysColumns Where id=Object_Id(''TableName'')
(2)¡¢SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length from syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND "syscolumns.id = object_id(''tableName'')
       ×¢Òâµã£º
     £¨a£©ÕâÀïΪÁËÖصãÍ»³öijЩÖØÒªÄÚÈÝ£¬Ñ¡È¡ÁËÆäÖм¸ÏîÐÅÏ¢Êä³ö¡£
     £¨b£©syscolumns±íÖÐÖ»º¬ÓÐÊý¾ÝÀàÐͱàºÅ£¬Òª»ñÈ¡ÍêÕûµÄÃû×ÖÐèÒª´Ósystypes±íÖÐÕÒ£¬Ò»°ãÓû§Ê¹ÓõÄÊý¾ÝÀàÐÍÓÃxusertype¶ÔÓ¦±È½ÏºÃ£¬²»»á³öÏÖÒ»¶Ô¶àµÄÇé¿ö¡£
     £¨c£©syscolumns.lengthµÃµ½µÄÊÇÎïÀíÄÚ´æµÄ³¤¶È£¬ËùÒÔnvarcharºÍvarcharµÈÀàÐÍÔÚÊý¾Ý¿âÖеÄÏÔʾÊÇÕâ¸öµÄÒ»°ë¡£
4¡¢µÃµ½±íÖÐÖ÷¼üËù°üº¬µÄÁÐÃû:
    SELECT syscolumns.name from syscolumns,sysobjects,sysindexes,sysindexkeys WHERE syscolumns.id = object_id(''tablename'') AND sysobjects.xtype = ''PK'' AND sysobjects.parent_obj = syscolumns.id AND sysindexes.id = syscolumns.id AND sysobjects.name = sysindexes.name AND sysindexkeys.id = syscolumns.id AND sysindexkeys.indid = sysindexes.indid AND syscolumns.colid = sysindexkeys.colid
×¢Ò⣺ÕâÊÇÔÚ4ÕÅϵͳ±íÖÐÑ°Õҵģ¬¹Øϵ±È½Ï¸´ÔÓ£¬´óÖ¿ÉÒÔ±íʾΪ£º
syscolumnsÖдæÓбíÖеÄÁÐÐÅÏ¢ºÍ±íid£¬sysobjects±íÖдæÓÐÖ÷¼üÃû×Ö£¨¼´PK_TableÀàËÆ£©ºÍ±íid£¬sysindexesÖдæ ÓÐÖ÷¼üÃû×ֺͱíidºÍindex±àºÅ£¬sysi