no

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 Northwi...

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';

Related

database 8508727746399191100

Post a Comment

item