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

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

angularjs - Showing an empty as first option in select tag -

php - Cloud9 cloud IDE and CakePHP -