While creating stored procedure in MSSQL DO NOT EVER FORGET to add "SET NOCOUNT ON"

Oracle:
 dbms_metadata.get_ddl() неплохо работает, из ком. строки
DB2:  db2 describe table (только список столбцов) , db2look (встроенная утилита)

MSSQL:

SELECT table_name=sysobjects.name,
column_name=syscolumns.name,
datatype=systypes.name,
length=syscolumns.length
FROM sysobjects
JOIN syscolumns ON sysobjects.id = ( Read more... )

Postgresql:
SELECT firstname, lastname, email
FROM contacts
LIMIT 10

MS SQL Server:
SELECT TOP 10 firstname, lastname, email
FROM contacts

ORACLE:
SELECT firstname, lastname, email
FROM contacts
WHERE ROWNUM <= 10

mySQL:
SELECT firstname, lastname, email
FROM contacts
LIMIT 10