SQL
Closed
raylop1
Posts
1
Registration date
Friday 22 April 2016
Status
Member
Last seen
22 April 2016
-
22 Apr 2016 à 12:54
Blocked Profile - 17 Oct 2016 à 18:07
Blocked Profile - 17 Oct 2016 à 18:07
Related:
- SQL
- Datediff sql oracle - Guide
- Sql dbx - Download - IDE
- Export database diagram sql server - Guide
- Oracle sql change password - Guide
- How to avoid duplicate records in sql - Guide
3 responses
Zohaib R
Posts
2368
Registration date
Sunday 23 September 2012
Status
Member
Last seen
13 December 2018
69
22 Apr 2016 à 15:32
22 Apr 2016 à 15:32
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.
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.
sandra_diaz
Posts
1
Registration date
Monday 5 September 2016
Status
Member
Last seen
17 October 2016
17 Oct 2016 à 05:38
17 Oct 2016 à 05:38
Hii,!!!!
Try below-listed command:-
Syntax:
SELECT column_name
FROM table_name;
Example:
SELECT PRODUCT
FROM Table_Name
Try below-listed command:-
Syntax:
SELECT column_name
FROM table_name;
Example:
SELECT PRODUCT
FROM Table_Name