sql获取所有数据库名、表名、储存过程以及参数列表（SQL gets all database names, table names, stored procedures, and parameter lists）.doc

sql获取所有数据库名、表名、储存过程以及参数列表（SQL gets all database names, table names, stored procedures, and parameter lists） SQL gets all database names, table names, stored procedures, and parameter lists 1. get all user names: SELECT, name, FROM, Sysusers, where, status=2, and, islogin=1 Islogin=1stands for accounts Islogin=0stands for roles Status=2represents a user account Status=0said the system account 2. get all database names: SELECT, Name, FROM, Master..SysDatabases, ORDER, BY, Name 3. get all table names SELECT, Name, FROM, DatabaseName..SysObjects, Where, XType=U, ORDER, BY, Name XType=U: represents all user tables; XType=S: stands for all system tables; 4. get all field names: SELECT, Name, FROM, SysColumns, WHERE, id=Object_Id (TableName) 5. get all types of databases Select name from systypes 6. get the primary key field SELECT, name, FROM, SysColumns, WHERE, id=Object_Id (table name), and, colid= (select, top,, keyno, from, sysindexkeys,, where, id=Object_Id (table name)) [integrated network data processing] 1. get all database names: (1) Select, Name, FROM, Master..SysDatabases, order, by, Name 2. get all table names: (1), Select, Name, FROM, SysObjects, Where, XType=U,, orDER, BY, Name XType=U: represents all user tables; XType=S: stands for all system tables; (2) SELECT, name, FROM, sysobjects, WHERE, type =U, AND, sysstat =83 Note: in general, you only need type =U, but sometimes the system tables are mixed (not knowing why), and you can delete these system tables after the next sentence 3. get all field names: (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) Watch out: (a) here, in order to highlight some important content, select several of these outputs. (b) a data type number table containing syscolumns, to get the full name from the systypes