Ask a question Report Reply to this topic

SQL [Closed]

raylop1 1 Posts Friday April 22, 2016Registration date April 22, 2016 Last seen - Apr 22, 2016 at 12:54 PM - Latest reply: ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen

- Oct 17, 2016 at 06:07 PM

Programming Ask a question Report Reply to this topic

I used the below command to view the tables, but I need the command to see each individual table to see how they are build each;

SQL> Select table_name from user_tables;

TABLE_NAME
------------------------------
PRODUCT
DEPARTMENT
JOB
CUSTOMERS
EMPLOYEE
JOB2
DEPARTMENT2
INVOICE
INVOICELINE

3 replies

Report Respond to Zohaib R

Zohaib R 2416 Posts Sunday September 23, 2012Registration dateModeratorStatus November 12, 2017 Last seen - Apr 22, 2016 at 03:32 PM

Helpful

Hi raylop1,

You can use sp_help [TableName] to get the Detailed Structure of any table in your Database. For example: for your PRODUCT table you can use:

sp_help [PRODUCT]

This will return the Detailed Structure of [PRODUCT] Table.

Please let us know if this was helpful.

Report Respond to sandra_diaz

sandra_diaz 1 Posts Monday September 5, 2016Registration date October 17, 2016 Last seen - Oct 17, 2016 at 05:38 AM

Helpful

Hii,!!!!
Try below-listed command:-

Syntax:
SELECT column_name
FROM table_name;

Example:
SELECT PRODUCT
FROM Table_Name

Report Respond to ac3mark

ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen - Oct 17, 2016 at 06:07 PM

Helpful

You could always connect to it,with SQuirreL and view it!

It's kind of fun to do the impossible! -Walter Elias Disney

Ask a question