This table lists equivalent functions, queries, etc. necessary to properly convert Drupal queries and .install files between MySQL and SQL Server 2000/2005/2008
| Database Equivalency Table | |||
|---|---|---|---|
| MySQL | MSSQL 2000 | MSSQL 2005 | MSSQL 2008 |
SHOW TABLES |
SELECT name FROM sysobjects WHERE xtype = 'U' |
||
ADD COLUMN x |
|||
view (e.g., as a column name) |
[view] (reserved keyword) |
||
DEFAULT NULL |
NULL DEFAULT NULL |
||
int unsigned |
int |
||