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
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
This wish will avoid that you have to manually edit a huge number of SQL files
Uniface Development Environment
Welcome to the online Uniface Community. The Uniface community site is a global communication channel for professional users of Uniface Enterprise Application Development