how can i find new sharepoint field in database?

Hi friends,

i have created a new filed in tasks in my sharepoint site.how can i find that field value in sql server data base table.if u know about that query send to me.
LVL 6
ramuar1981Asked:
Who is Participating?
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
here is how you query the data in sql:
http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx

to make the process easier (and to heed the MS warning to only query sharepoint list data in a supported manner), you might consider SLAM:
http://slam.codeplex.com/
0
 
samer_othman82Connect With a Mentor Commented:
i can give you a query to search for the new column inside the whole database
just change the name of the datbase and the new column name you had add

select DISTINCT <DabaseName>.sys.tables.name AS TableName,   <DabaseName>.sys.all_columns.name as FiledName,  <DabaseName>.sys.all_columns.column_id
from  <DabaseName>.sys.tables,  <DabaseName>.sys.all_columns
where <DabaseName>.sys.all_columns.name like '%<columnname>%'

I hope this will help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.