RE: Describing a table structure

From: mark.laffey (mark.laffey_at_littlewoodsgaming.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 02:46:30 -0800

Hi,

there may be other ways, but this gives the info in more
or less the same format as you get in Oracle. Just make
sure that you select 'Results in grid' from the Query tab.
Jig,
 that is the correct format

Mark
 
>-----Original Message-----
>is that the only way?
>
>"Nigel Rivett" wrote:
>
>> Do you mean
>> sp_help tblname
>>
>> "Jig Bhakta" wrote:
>>
>> > Hi,
>> >
>> > I would like to know the syntax in MS SQL 2K for
describing a table, without
>> > having to expand everything in the object browser.
>> >
>> > I know in Oracle it is: desc <table_name>;
>> >
>> > Thanks,
>> >
>> > Jig.
>.
>

Relevant Pages

  • Re: Date Formats
    ... tables of SQL Server. ... I had problem in exporting these fields into Oracle. ... > I presume that the problem is that Oracle doesn't interpret the datetime values from SQL server ... > a format, hence trying to enforce a format for that datatype is meaningless. ...
    (microsoft.public.sqlserver.programming)
  • Re: No one could logon to productio database for a while
    ... Puget Sound Oracle Users Group ... code for script is quite simple, it does a v$sql to find all sql ... The script ask for the hash value of the SQL statement. ... col "SLAVE SQL" format A95 WORD_WRAP ...
    (comp.databases.oracle.server)
  • RE: timestamp datatype
    ... You must tell Oracle what format your DATE or TIMESTAMP data is in, ... rather than the raw Oracle DATE or TIMESTAMP format. ...
    (perl.dbi.users)
  • Re: Limit on number of mail merge fields in Word 2007/XP
    ... produce an HTML table or other format as you suggest below? ... "Peter Jamieson" wrote: ... Are you in a position to use an Oracle View or Table directly as the data ... past when the line length of a line in Word exceeds around 1500 ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Limit on number of mail merge fields in Word 2007/XP
    ... if they are using the Word object model to create a Word document for use as a data source, the simplest /type/ of change they could probably make would be to generate a Word document with a different internal format - that's regardless of whether they are using Word VBA, or the "full" VB, VBScript or some other application's VBA, as long as it's capable of driving the Word object model. ... "Peter Jamieson" wrote: ... Are you in a position to use an Oracle View or Table directly as the data ...
    (microsoft.public.word.mailmerge.fields)