mariadb及mssql的对比用法

一、查询表字段：

1. mssql：select syscolumns.name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='human_basic_data') order by syscolumns.colid
2. mariadb：SELECT   COLUMN_NAME FROM information_schema.`COLUMNS`  where TABLE_SCHEMA like 'TCDHRMS' and  TABLE_NAME like 'human_basic_data'  

二、索引/主键：

    1.mssql：

             SELECT OBJECT_ID,OBJECT_NAME(i.[object_id]) AS tableName, NAME, i.is_disabled   

FROM sys.indexes AS i WHERE i.[object_id]=OBJECT_ID('human_basic_data')  --查询索引

ALTER INDEX IX_human_basic_data_1 ON human_basic_data disable  --关闭索引