Contenu supprimé Contenu ajouté
|
|
|
[[Motî:_lete U|U]],
[[Motî:_lete V|V]]
----
select '!!!Database Schema', '1' as [dorder]
union all
select '!!!!' + o.name, '2.' + o.name + '.0' [dorder]
from sysobjects o where o.type = 'U' and o.name like 'forums%'
union all
select '||''''''Column Name''''''||''''''Data Type''''''||''''''Nullable''''''||''''''Key''''''||''''''Description''''''||', '2.' + o.name + '.1' [dorder]
from sysobjects o where o.type = 'U' and o.name like 'forums%'
union all
select '||[' + c.name + ']||' + type_name(c.xusertype) + '(' + convert(varchar(20), convert(int, c.length)) + ')' + '||' + case when c.isnullable = 0 then 'no' else 'yes' end + '||||||'
, '2.' + o.name + '.2.' + convert(varchar(20), c.colid) [dorder]
from sysobjects o inner join syscolumns c on o.id = c.id where o.type = 'U' and o.name like 'forums%'
order by 2, 1
|
