no

What Is the Mssql Equivalent of Desc in Mysql

Long time ago I was executing the command that I'm so used to in mysql which is: desc tablename This command will give you the rows,...

Long time ago I was executing the command that I'm so used to in mysql which is:

desc tablename

This command will give you the rows, its datatype, length, description etc.

I've tried executing this in MSSQL and it's not working tried: describe, desc but failed. I also tried manually selecting the columns from information_schema.columns but it's too ugly. Luckily digging to the documentation I found the stored procedure:

sp_columns which has the same functionality as desc.

Usage:


sp_columns tablename

Related

rbdms 3952722525537359538

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