how can i find new sharepoint field in database?

Hi friends,

i have created a new filed in tasks in my sharepoint can i find that field value in sql server data base table.if u know about that query send to me.
Who is Participating?
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
here is how you query the data in sql:

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:
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> AS TableName,   <DabaseName> as FiledName,  <DabaseName>.sys.all_columns.column_id
from  <DabaseName>.sys.tables,  <DabaseName>.sys.all_columns
where <DabaseName> like '%<columnname>%'

I hope this will help
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.