ORACLE :
--Time Turn string
To_char (sysdate, ' Yyyymmddhh24miss ')
--String Turn time
Select To_date (' 20140701125751 ', ' Yyyymmddhh24miss ') from dual--2014-07-01 12:57:51
--Query table
SELECT * FROM all_tables WHERE table_name = ' {0} '
--Query column
SELECT
Aa.table_name as Tableename,
Aa.column_name as ColName,
NVL (Bb.comments, aa.column_name) as Coldesc
From
(
SELECT
TABLE_NAME,
COLUMN_NAME,
Comments
From
All_col_comments
WHERE
table_name = ' {0} '
and owner = ' {1} ') BB,
(
SELECT
TABLE_NAME,
COLUMN_NAME,
column_id
From
All_tab_columns
WHERE
table_name = ' {0} '
and owner = ' {1} ') AA
WHERE
Aa.column_name = Bb.column_name
ORDER by
aa.column_id ASC
DB2:
--Time Turn string
To_char (timestamp_expression, ' yyy-mm-dd HH24:MI:SS ')
--String Turn time
To_date (string_expression, ' yyy-mm-dd HH24:MI:SS ')
--Query table
SELECT * from SYSCAT. TABLES WHERE tabname = ' {0} '
--Query column
SELECT
TabName as Tableename,
ColName,
NVL (remarks, colname) as Coldesc
From
SYSCAT. COLUMNS
WHERE
TabName = ' {0} '
and Tabschema = ' {1} '
ORDER by
Colno ASC
Sql server:
--Time Turn string
Replace (replace (CONVERT (varchar, GETDATE (), 120), '-', '), ': ', '), ', ')
--String Turn time
Http://www.cnblogs.com/windphoenix/archive/2013/04/26/3044784.html
--Query table
SELECT * from sysobjects where xtype= ' U ' and name = ' {0} '
--Query column
Select Dbo.syscolumns.name as ColName, CONVERT (Varchar (), Isnull (Sys.extended_properties.value, Dbo.syscolumns.name)) as Coldesc from dbo.sysobjects inner join dbo.syscolumns on (dbo.syscolumns.id = Dbo.sysobjects.id ) left join sys.extended_properties on (dbo.syscolumns.id = sys.extended_properties.major_id and syscolumns.colid= sys.extended_properties.minor_id) where dbo.sysobjects.xtype= ' U ' and dbo.sysobjects.name = ' {0} '
Mysql:
---time-to-go string
Select Date_format (now (), '%y%m%d%h%i%s ')--20150425102256
--String Turn time
SELECT str_to_date (' 20150425102222 ', '%y%m%d%h%i%s '); --2015-04-25 10:22:22
--Query table
Selecttable_name as tablename,table_comment as Tabledesc Frominformation_schema.tables where table_name not like ' T ' ORDE R by TABLE_NAME;
--Query column
select* from information_schema.columns WHERE table_name = ' T ';
Sqlite:
--Time Turn string
Strftime ('%y%m%d%h%m%s ', ' Now ')
--String Turn time
http://blog.csdn.net/xmphoenix/article/details/6438854
Http://www.cnblogs.com/ungshow/archive/2010/10/10/1847081.html
--Query table
SELECT * fromsqlite_master where type= ' table ' Andname = ' {0} '
--Query column
PRAGMA Table_info ([T1])
Oracle-db2-sqlserver-mysql Database time conversion query table structure