Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.sybase > #583 > unrolled thread
| Started by | SpreadTooThin <bjobrien62@gmail.com> |
|---|---|
| First post | 2011-12-08 14:31 -0800 |
| Last post | 2011-12-09 13:17 -0800 |
| Articles | 4 — 2 participants |
Back to article view | Back to comp.databases.sybase
sybase newb... SpreadTooThin <bjobrien62@gmail.com> - 2011-12-08 14:31 -0800
Re: sybase newb... bret_halford@msn.com - 2011-12-09 09:59 -0800
Re: sybase newb... SpreadTooThin <bjobrien62@gmail.com> - 2011-12-09 12:54 -0800
Re: sybase newb... SpreadTooThin <bjobrien62@gmail.com> - 2011-12-09 13:17 -0800
| From | SpreadTooThin <bjobrien62@gmail.com> |
|---|---|
| Date | 2011-12-08 14:31 -0800 |
| Subject | sybase newb... |
| Message-ID | <e4686f46-ad72-401c-8f58-a9aa3ea6bda4@18g2000prn.googlegroups.com> |
I'm trying to figure out the column names in a table... I'm use to SQL and saying something like DESCRIBE TableName; What is the sybase equivalent?
[toc] | [next] | [standalone]
| From | bret_halford@msn.com |
|---|---|
| Date | 2011-12-09 09:59 -0800 |
| Message-ID | <8fcef7ed-9fa4-4584-b178-1da52f0ab4d6@v11g2000yqi.googlegroups.com> |
| In reply to | #583 |
On Dec 8, 3:31 pm, SpreadTooThin <bjobrie...@gmail.com> wrote:
> I'm trying to figure out the column names in a table...
> I'm use to SQL and saying something like DESCRIBE TableName;
> What is the sybase equivalent?
For ASE,
execute sp_help TableName
or for a more raw view of the data, just the column names
select name from syscolumns where id = object_id("TableName")
[toc] | [prev] | [next] | [standalone]
| From | SpreadTooThin <bjobrien62@gmail.com> |
|---|---|
| Date | 2011-12-09 12:54 -0800 |
| Message-ID | <24635339.743.1323464084898.JavaMail.geo-discussion-forums@prfb7> |
| In reply to | #584 |
Thank you very much. name is one column but are there others that might help me determine the structure of the table?
[toc] | [prev] | [next] | [standalone]
| From | SpreadTooThin <bjobrien62@gmail.com> |
|---|---|
| Date | 2011-12-09 13:17 -0800 |
| Message-ID | <12052430.446.1323465464552.JavaMail.geo-discussion-forums@prht13> |
| In reply to | #586 |
found this... http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables22.htm
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.sybase
csiph-web