汇总一下各种数据库查询数据库里所有表的名称及指定表的字段及其数据类型的SQL

SQL Server

1 select name from sysobjects where type='U' --表2 sp_columns 'TableName' --字段信息 3 SELECT [name] FROM SysColumns WHERE id=Object_Id('TableName')

SQLite

1 select name from sqlite_master where type='table' --表2 PRAGMA table_info([TableName]) --字段信息

MySQL

select * from information_schema.tables --表select column_name,data_type from information_schema.columns where table_schema=’DataBaseName’ and table_name=’TableName’ --字段信息

Oracle

select * from all_tables WHERE owner='DataBaseName' --表select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=TableName]; --字段信息