convert mySql query into Sql Server query

[Sairan]

hi
can anyone tell me the substitute of the sql query

DESC table_name

in SQl Server query.

i'm trying to access the structure of a table but the query doesn't work for SQL Server 2000

[Shuja Ali]

Well there is no substitute as such to the DESC command but there is a stored procedure that you can use to get the structure of the table. sp_help TABLE_NAME

[Sairan]

my problem is resolved by using the query

CREATE PROCEDURE Describe_table (@table_name varchar) AS
SET NOCOUNT OFF
Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @table_name
GO

thanks for the reply
regards
Sairan