luboshl / aseisql

Automatically exported from code.google.com/p/aseisql
0 stars 0 forks source link

Table DDL shows DEFAULT along with create index command #78

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Open database object browser
2. select table, right click and select table DDL
3. The output contains line 'with DEFAUTL getdate()' after create index 
command

What is the expected output? What do you see instead?
The expected result is create index command, but Defaults are also seen 
along with it

What version of the product are you using? On what operating system?
same problem with all versions.

Please provide any additional information below.
the DDL extracted using other tools is good.

Original issue reported on code.google.com by rakesh...@gmail.com on 24 Mar 2010 at 9:45

GoogleCodeExporter commented 9 years ago
This is an alternative, but It's not recommended:

In the file "stubs.sql" search for the text and commnent it:
   if isNull(@default,'')!=''
   insert into #tmp
   select object_id(@tabname),@cdefault,3,char(9)+"with " + @default
near line 1042.

This is not recommended because the beginning of the file explicitly says:
--THIS FILE IS RESERVED FOR STANDARD STUFF.
-- IF YOU NEED TO ADD HERE SOMETHING PLEASE INFORM ME BY EMAIL dlukyanov@ukr.net

Original comment by juliocro...@gmail.com on 2 Mar 2011 at 4:52