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,...
https://www.czetsuyatech.com/2021/07/mysql-mssql-desc-equivalent.html
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:
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
Post a Comment