How to export the table structure with column details

Sagaya1
Giga Expert

HI ,

I need to export servicenow table and its column details  only . Please help to provide details 

 

Regards,

Sagaya Rajan.

1 ACCEPTED SOLUTION

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Thank you @Sagaya . Appreciate your consideration. The reason I have asked was ONLY because the response from other user was the same response I have shared initially.

View solution in original post

10 REPLIES 10

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Please refer https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/exporting-data/co.... You should navigate to sys_dictionary table and apply filters with table as **Select your Table Name** to export the table columns you want.

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Screenshot for reference.

find_real_file.png

Ankur Bawiskar
Tera Patron
Tera Patron

@Sagaya 

Do you need to export all table and it's column details?

Can you explain the business use-case/requirement around this?

Do you want to migrate few table and it's column across the instance?

If yes then this gets automatically captured in update set.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

@Sagaya - Just in case if you are looking to export records to different instances. There are two options.

1. Create update set and capture it

2. Export records via XML if this is one time https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/development-best-...