Table DDL shows DEFAULT along with create index command
Opened this issue · 1 comments
GoogleCodeExporter commented
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
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