Alter scripts and schema name

[denmarkdev]

When I'm doing an "Edit table" and then using "View SQL" to see the alter SQL I'll like it to always prefix it with schema name. Is this possible?

 

[Marco Kalter]

The schema name is omitted if you are connected as the owner. It is included if you are connected as another user.

 

[denmarkdev]

I know. But I'm always connected as the owner and then I do not get the schema name. I find it cumbersome to log in as e.g. sys user to get the alter SQL with the schema name. Could it be added as an option?

 

[denmarkdev]

Lots of my colleagues forget the schema name because of this! Off course I don

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[denmarkdev]

thanks