× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
samjacinto reported 2018-06-15T17:24:15Z  · swetha last modified 2019-12-17T08:05:36Z

Case #00638692 - Is there a way that I can disable storage clause


customer request M2_V20.5 V20.5
Priority Major
Complexity Unknown
Component App - New Features
Version 20.5

When generating schema scripts, I have the ability to include or exclude
the storage options for a table. However, when the primary key constraint
is generated, it includes the storage clause. Is there a way that I can
disable that? If not, please consider that feature in the future.

I'm using MS Sql Server. Two tables from my schema are shown below. The
second has a primary key. I want to move these tables to another database
that doesn't have a file group named [ARP_METAData01].

MSSql Server
CREATE TABLE "dbo"."BKP_transformation_target_field" (
"transformation_target_field_id" int IDENTITY(1,1) NOT NULL,
"transformation_target_id" int NOT NULL,
"data_element_id" int NOT NULL,
"execution_order" int NULL,
"business_rule_type_id" int NOT NULL,
"business_rule" nvarchar(max) NULL,
"business_rule_owner_id" int NOT NULL
)
GO
CREATE TABLE "dbo"."Component" (
"Component_id" int IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
"Structure_id" int NULL,
"Data_Element_id" int NULL,
CONSTRAINT "PK__Componen__DA7521125EDC5785" PRIMARY KEY
CLUSTERED("Component_id")
ON [ARP_METAData01])
GO

 

Product: Aqua Data Studio

Version: 19.0.0
Build #: 55797
Build Date: 2018-Apr-24 08:26:49 AM

Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle
Corporation 1.8.0_102-b14
Memory: Max=1,060,634,624; Total=1,060,634,624; Free=357,733,544; CPUs=8

In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) HD Graphics 630
OpenGL Version: 4.4.0 - Build 21.20.16.4664
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1380 ms


Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 43 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600

 

Using the [DEFAULT] keyword would work. Another option would be to omit it

altogether yielding something like this:

CREATE TABLE [dbo].[t3] (
[c1] int NOT NULL,
[c2] varchar(25) NULL,
CONSTRAINT [p2] PRIMARY KEY CLUSTERED([c1]))
WITH (
DATA_COMPRESSION = NONE
)
GO

Since the benefit, in my opinion, of generating 'Create Table' statements
from an existing database is to rebuild the table(s) on another database, a
better option would be to allow the user to specify the file group for
storage. In that case, for both data and indexes, the user would either
check a box to exclude the storage clause or manually enter the name of the
file group to use.

So, yes, assuming this explanation makes sense, please open a feature
request.

2 attachments

Issue #15598

Verified
Fixed
Resolved 2019-09-16T07:33:52Z
 
 
Completion
No due date
Fixed Build 57047
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017