开发者

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

开发者 https://www.devze.com 2023-01-05 01:01 出处:网络
I am using Oracle SQL Developer in a linux environment to connect开发者_JAVA技巧 to an SQL Server 2005.

I am using Oracle SQL Developer in a linux environment to connect开发者_JAVA技巧 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


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

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


Have you tried exec sp_helptable [table_name]?


this works: exec sp_helptable 'table_name'


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


exec sp_help [db.schema.table] works

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号