该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
public string SqlField()
{
string sql = @"
SELECT
COL.COLUMN_ID F_NUMBER,
COL.COLUMN_NAME F_COLUMN,
COL.DATA_TYPE F_DATATYPE,
COL.DATA_LENGTH F_LENGTH,
NULL F_IDENTITY,
CASE UC.CONSTRAINT_TYPE
WHEN 'P' THEN
1
ELSE
NULL
END F_KEY,
CASE COL.NULLABLE
WHEN 'N' THEN
0
ELSE
1
END F_ISNULLABLE,
COL.DATA_DEFAULT F_DEFAULTS,
COMM.COMMENTS AS F_REMARK
FROM
USER_TAB_COLUMNS COL
INNER JOIN USER_COL_COMMENTS COMM ON COMM.TABLE_NAME = COL.TABLE_NAME
AND COMM.COLUMN_NAME = COL.COLUMN_NAME
LEFT JOIN USER_CONS_COLUMNS UCC ON UCC.TABLE_NAME = COL.TABLE_NAME
AND UCC.COLUMN_NAME = COL.COLUMN_NAME
AND UCC. POSITION = 1
LEFT JOIN USER_CONSTRAINTS UC ON UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME
AND UC.CONSTRAINT_TYPE = 'P'
WHERE
COL.TABLE_NAME = : TABLENAME
ORDER BY
COL.COLUMN_ID";
return sql;
}
public string SqlTable()
{
string sql = @"
SELECT DISTINCT
COL.TABLE_NAME NAME,
0 RESERVED,
0 FDATA,
0 INDEX_SIZE,
NVL (T.NUM_ROWS, 0) SUMROWS,
0 FUNUSED,
TAB.COMMENTS TDESCRIPTION,
COLUMN_NAME PK
FROM
USER_CONS_COLUMNS COL
INNER JOIN USER_CONSTRAINTS CON ON CON.CONSTRAINT_NAME = COL.CONSTRAINT_NAME
INNER JOIN USER_TAB_COMMENTS TAB ON TAB.TABLE_NAME = COL.TABLE_NAME
INNER JOIN USER_TABLES T ON T.TABLE_NAME = COL.TABLE_NAME
WHERE
CON.CONSTRAINT_TYPE NOT IN ('C', 'R')
ORDER BY
COL.TABLE_NAME";
return sql;
}