| 目標 | mysql | mssql |
|---|---|---|
| 查詢資料庫名稱 | show databases; | select name from sys.databases order by name asc |
| 查詢資料表名稱 | show tables; | select name from sys.tables order by name asc |
| 查詢欄位名稱 | show columns from 資料表名稱; | select a.name as table_name, b.name as column_name from sys.tables as a inner join sys.columns as b on b.object_id=a.object_id order by a.name asc, b.column_id asc |
| 查詢欄位資訊 | select COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='資料表名稱' | |
| 顯示資料表細節 | show create table 資料表名稱; | exec sp_help 資料表名稱 (最接近的寫法) |