Description


The create table utility for Sybase can be enhanced in the following way: 1.) If you have a bit value, Sybase doesn\\\'t allow a null into this field. Therefore you should define a default of 0. 2.) It is good practise in SQL files to drop the table if it already exists. Therefore a command like if exists (select * from sysobjects where name = \\\'\\\' and type = \\\'U\\\') begin drop table
end go will be helpful

Use Case


The best way for point 1 is: To use either the default value 0 or the initial value The best way for point 2 is: That there is a checkbox if the drop command should be generated or not

Importance


This wish will avoid that you have to manually edit a huge number of SQL files

Type


Uniface Development Environment

Operating System


Windows

Status


Open

Leave a Reply

Welcome to the online Uniface Community. The Uniface community site is a global communication channel for professional users of Uniface Enterprise Application Development