Hi

You can use sp_excutesql sp to create a dynamic sql

e.g sp_executesql(@sqlstmt)

note : @sqlstmt should be nvarchar(4000) maximum.

Another way is execute method.

e.g. exec (@sqlstr)

where @sqlstr contains the any executable select statement.

...

Hi!

This will solve your problem!!!

select a.id as Tableid,a.Name as TableName,b.name as colName,b.colid as colId,

d.name as constraintname,d.xtype as constrainttype , e.name

from ((((sysobjects a inner join syscolumns b

on a.id=b.id)...

HI!

what you can do in visula basic only save the field name in tag property of object. use a loop to check the value has been filled by the user...