Search code examples
sqlsql-serveroracle-databasesql-query-store

Oracle query to SQL Server query

What is the equivalent sql sever query for 

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
Solution

  • this is a standard sql query syntax!