× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2013-11-05T16:11:29Z  · last modified 2014-06-30T18:36:08Z

Support for "in row" feature and research for any other new options in Sybase ASE 15.7+


customer request
Priority Major
Complexity Unknown
Component App - Visual Editing
Version 15.0

Support for "in row" feature and research for any other new options in Sybase ASE 15.7+

1.) A feature request for Sybase ASE 15.7+ in the Create Table visual editor to include support in-row in the Column Properties for LOB's like TEXT data type etc. 

2.) The in row property should also be scripted in Script to Window -> Create

3.) Check for any more new changes in Sybase ASE 15.7

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1572/html/commands/X80969.htm

Sample Create Table SQL :

 

CREATE TABLE dbo.Signal (
        signalID        int NOT NULL,
        message         text NULL in row (1024)
)
go
 
SQL
-------
select case when status2 & 262144 = 262144
            then 'in row: ' + convert(varchar(10), inrowlen)
       end
from syscolumns
where name = 'message'
and object_name(id) = 'Signal'

Issue #10689

Closed
Fixed
Resolved 2013-11-09T19:36:38Z
 
 
Completion
No due date
No fixed build
No time estimate

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