How to call sp_help [table] for SQL Server when using Oracle SQL Developer as my client

Question

I am using Oracle SQL Developer in a linux environment to connect to an SQL Server 2005.

I don't seem to be able to make a sp_help [table_name] call. Previously, I found it quite useful when I was on a Windows environment using SQL Server management, and could make that call.

Is there any way to do this?

[edit] error message returned is the following:

Error starting at line 1 in command:
sp_help city
Error report:
Unknown Command

Answer 1

Have you tried 'exec sp_helptable [table_name]'?

Answer 2

Sorry to say this, but SQL Server won't care about the string it's sent in the batch so it's problem with the client or the driver.

If you have to use Linux, try SQuirreL instead which is a vey nice tool

Answer 3

Have you considered using the information_schema views instead. E.g.

Select * from information_schema.columns where table_name = 'City'