can u give me any example please....i am saying that suppose

create table test1 (name varchar(20), age int)

is create so by any mode apart from gui i can check its ddl creation statement if yesreply then i need any dbcc, sp, dmv

if ddl trigger is only method then need the example of it..please