Hi, whenever I run this command:
SELECT dbms_metadata.get_ddl('TABLE', 'MY_TABLE')
FROM DUAL;
I am getting the schema name and storage details, when all I want is the logical definition of the table. I went to Settings > Extensions > Oracle SQL Developer Extensions for VSCode and viewed my settings. I have my setting Emit Schema set to “off”, however, I still get the schema information when running get_ddl
. For instance, on a real table I will get CREATE TABLE MY_SCHEMA.MY_TABLE
, when I would expect that I should get CREATE TABLE MY_TABLE
. Just in case I have my wires crossed, I set Emit Schema to “on” and tried again, so either way the name of my schema is being emitted in the CREATE TABLE
statement.
This is easy enough to remove, but it is also happening with the Storage setting. I don't want the storage clauses included in my ddl, but I am getting a lot of clauses related to storage including segment creation
, tablespace
, storage
, etc. Like before, I also tried turning the setting off/on and there seems to be no discernable difference in the output.
Is this an issue with the latest release, or am I simply doing something incorrectly?