c# - How can I fetch non-english column names from a table in SQL Server 2008? -
i have created items_table. columns' name of table ਸੋਯਾਬੀਨ , ਕਨ੍ਨੀ , in language other english. created columns using
alter table item_table add "+item.text+" nvarchar(50);
where non-english column name entered in textbox on ui. in next step want fetch column names table , add them item in combobox in c# app. want know query can fetch non-english column names. using query-->> select * information_schema.columns table_name=n'item_table'
and returns name of database.
based on little info posted, assume you're looking information_schema
.
select * information_schema.columns
or
select * information_schema.columns table_name=n'mytable'
Comments
Post a Comment