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

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