no

Desc Query in Mssql Similar to Mysql

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

rdbms 8508727746399191100

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item