Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

Mysql desc operation in mssql. This query imitate the desc operation from mysql into mssql

This query imitate the desc operation from mysql into mssql. It produces the columns and descriptions of the Products table from the Northwind database.


SELECT
column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS a
INNER JOIN information_schema.columns AS b
ON a.table_catalog = b.table_catalog
AND a.table_schema = b.table_schema
AND a.table_name = b.table_name
WHERE a.table_name = 'Products';
Mysql desc operation in mssql. This query imitate the desc operation from mysql into mssql Mysql desc operation in mssql. This query imitate the desc operation from mysql into mssql Reviewed by Edward Legaspi on Thursday, June 03, 2010 Rating: 5

No comments:

Powered by Blogger.