no

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

.net 3952722525537359538

Post a Comment

item