close
MS SQL SERVER :

SELECT * FROM INFORMATION_SCHEMA.TABLES

OR

EXEC SP_TABLES @TABLE_TYPE="'TABLE'"

=============================================

ORACLE:

SELECT OBJECT_NAME
FROM SYS.USER_OBJECTS
WHERE OBJECT_TYPE='TABLE'
arrow
arrow
    全站熱搜

    thoao 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄