sql - Oracle 查询到 SQL Server 查询

Question

什么是等效的 sql server 查询

SELECT Table_Name,
       Column_Name,
       Data_Type,
       Data_Length,
       Data_Precision,
       Data_Scale, Nullable,
       Character_Set_Name,
       Char_Col_Decl_Length,
       Char_Length
FROM all_tab_cols ORDER BY Table_Name, Column_Id

标签： sqlsql-serveroraclesql-query-store

Answer 1

可能这就是你要找的..

SELECT TABLE_SCHEMA ,TABLE_NAME ,COLUMN_NAME
,ORDINAL_POSITION,COLUMN_DEFAULT,IS_NULLABLE,DATA_TYPE 
,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,COLLATION_NAME
,*
FROM INFORMATION_SCHEMA.COLUMNS