sybase.sql 3.5 KB

1234567891011121314151617181920212223242526272829
  1. -- https://www.51cto.com/article/235614.html
  2. -- https://www.cnblogs.com/jinzhenshui/archive/2010/05/26/1744179.html
  3. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'char');
  4. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'varchar');
  5. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'text');
  6. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'nchar');
  7. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'nvarchar');
  8. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'ntext');
  9. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'uniqueidentifier');
  10. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'xml');
  11. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'LONG', 9, 'bigint');
  12. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'decimal');
  13. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'money');
  14. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'smallmoney');
  15. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'numeric');
  16. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'INTEGER', 9, 'int');
  17. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'INTEGER', 9, 'smallint');
  18. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'INTEGER', 9, 'tinyint');
  19. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DOUBLE', 9, 'float');
  20. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'FLOAT', 9, 'real');
  21. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'time');
  22. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'date');
  23. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'datetime9');
  24. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'datetimeoffset');
  25. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'datetime');
  26. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'smalldatetime');
  27. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'bit');
  28. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'binary');
  29. INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'varbinary');