Do you need to check which are the columns for a particular table?
If you need to check which columns are in a particular table, with Oracle databases you can use command desc:
SQL> desc “SAPGFP”.”T000″
Name |
Null? | Type |
---|---|---|
MANDT |
NOT NULL | VARCHAR2(9) |
MTEXT | NOT NULL | VARCHAR2(75) |
ORT01 | NOT NULL | VARCHAR2(75) |
MWAER | NOT NULL | VARCHAR2(15) |
ADRNR | NOT NULL | VARCHAR2(30) |
CCCATEGORY | NOT NULL | VARCHAR2(3) |
CCCORACTIV | NOT NULL | VARCHAR2(3) |
CCNOCLIIND | NOT NULL | VARCHAR2(3) |
CCCOPYLOCK |
NOT NULL |
VARCHAR2(3) |
CCNOCASCAD | NOT NULL | VARCHAR2(3) |
CCSOFTLOCK | NOT NULL | VARCHAR2(3) |
CCORIGCONT | NOT NULL | VARCHAR2(3) |
CCIMAILDIS | NOT NULL | VARCHAR2(3) |
CCTEMPLOCK | NOT NULL | VARCHAR2(3) |
CHANGEUSER | NOT NULL | VARCHAR2(36) |
CHANGEDATE | NOT NULL | VARCHAR2(24) |
LOGSYS | NOT NULL | VARCHAR2(30) |
Within SQL Server we do not have the same command but we can use the following statement:
select COLUMN_NAME, IS_NULLABLE, DATA_TYPE
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='T000'
* More columns from INFORMATION_SCHEMA.COLUMNS can be selected if necessary
COLUMN_NAME |
IS_NULLABLE | DATA_TYPE |
---|---|---|
MANDT |
NO | NVARCHAR |
MTEXT | NO | NVARCHAR |
ORT01 | NO | NVARCHAR |
MWAER | NO | NVARCHAR |
ADRNR | NO | NVARCHAR |
CCCATEGORY | NO | NVARCHAR |
CCCORACTIV | NO | NVARCHAR |
CCNOCLIIND | NO | NVARCHAR |
CCCOPYLOCK |
NO |
NVARCHAR |
CCNOCASCAD | NO | NVARCHAR |
CCSOFTLOCK | NO | NVARCHAR |
CCORIGCONT | NO | NVARCHAR |
CCIMAILDIS | NO | NVARCHAR |
CCTEMPLOCK | NO | NVARCHAR |
CHANGEUSER | NO | NVARCHAR |
CHANGEDATE | NO | NVARCHAR |
LOGSYS | NO | NVARCHAR |
Also, sp_help (much more information about the object) can be used:
sp_help 'sm1.T000'
Results in the attached file sp_help T000.txt.zip.
And of course use transaction DBACockpit:
Hope you like this blog and any comment/suggestion are welcome!
Regards,
Eduardo
Nice! Thanks for sharing it!