There is no query to get the description of the table like in MySQL. Use sp_columns stored procedure to describe the table in SQL Server.
exec sp_columns tableName;
And also we can use sp_help to describe the table. sp_help is returned depend on whether name is specified, when it is specified, and what database object it is.
exec sp_help tableName;
exec sp_columns tableName;
And also we can use sp_help to describe the table. sp_help is returned depend on whether name is specified, when it is specified, and what database object it is.
exec sp_help tableName;
Comments
Post a Comment