Add @ symbol
Private Static string SQL = @ "select sysobjects. name as table_name, syscolumns. ID, syscolumns. name as column_name, policypes. name as data_type, syscolumns. length as character_maximum_length, sys. extended_properties. [value] As column_description, syscomments. text ascolumn_default, syscolumns. isnullable as is_nullable from syscolumnsinner join policypes on syscolumns. xtype = policypes. xtype left join sysobjects on syscolumns. id = sysobjects. id left Outer Join sys. extended_properties on (sys. extended_properties.minor_id = syscolumns. colid and SYS. extended_properties.major_id = syscolumns. ID) left Outer Join syscomments on syscolumns. cdefault = syscomments. ID where syscolumns. ID in (select ID from sysobjects where xtype = 'U') and (policypes. name <> 'sysname') order by syscolumns. colid ";
Private Static string SQL = @ "select sysobjects. Name as table_name, syscolumns. ID, syscolumns. Name as column_name,
Policypes. Name as data_type, syscolumns. length as character_maximum_length,
SYS. extended_properties. [value] As column_description, syscomments. Text
Column_default, syscolumns. isnullable as is_nullable from syscolumns
Inner join policypes
On syscolumns. xtype = policypes. xtype
Left join sysobjects on syscolumns. ID = sysobjects. ID
Left Outer Join SYS. extended_properties on
(SYS. extended_properties.minor_id = syscolumns. colid
And SYS. extended_properties.major_id = syscolumns. ID)
Left Outer Join syscomments on syscolumns. cdefault = syscomments. ID
Where syscolumns. ID in
(Select ID from sysobjects where xtype = 'U') and (policypes. Name <> 'sysname ')
Order by syscolumns. colid ";
Private Static string SQL = @ "select sysobjects. name as table_name, syscolumns. ID, syscolumns. name as column_name, policypes. name as data_type, syscolumns. length as character_maximum_length, sys. extended_properties. [value] As column_description, syscomments. text ascolumn_default, syscolumns. isnullable as is_nullable from syscolumnsinner join policypes on syscolumns. xtype = policypes. xtype left join sysobjects on syscolumns. id = sysobjects. id left Outer Join sys. extended_properties on (sys. extended_properties.minor_id = syscolumns. colid and SYS. extended_properties.major_id = syscolumns. ID) left Outer Join syscomments on syscolumns. cdefault = syscomments. ID where syscolumns. ID in (select ID from sysobjects where xtype = 'U') and (policypes. name <> 'sysname') order by syscolumns. colid ";