#11294: Defaults already present in the database are not displayed in dropdown list of default values while creating table in Sybase ASE

saima.alvi(*) reported 2014-01-08T05:36:56Z · last modified 2014-07-02T04:10:00Z

Dev	JohnLH
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	App - Visual Editing
Version	Future - 0.1

Build #: 35415

Built on: 2014-Jan-03 09:09:58 AM

Operational environment:Windows 7(6.1,amd64)/Cp1252/1.7.0_2

Database:Sybase ASE 15.7

Issue:Defaults already present in the database are not displayed in dropdown list of default while creating table.

Steps to reproduce:

1)Connect to Sybase ASE->In any database create one default with script

CREATE DEFAULT "dbo"."datedflt" AS getdate()

2)Create new table in same database and try to bind a default on one column,

you will observe that the defaults already present in database are not displayed in defaults dropdown list while creating table.

All Comments (1) Change History

saima.alvi(*) 2014-07-02T04:10:00Z

Same issue occures in SQL server