Check if table exists in MS SQL database
I needed to check if the tables are in the database or not. Here is an example of the SQL query - it returns 1 if one of the tables exists and 0 if they do not exist.
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_NAME = 'RoleClaims' or TABLE_NAME = 'Users')
SELECT 1
ELSE
SELECT 0You can use this code if you need to check if tables exist. For example, to create tables in case if nullable result
Get available options for Choice SharePoint field with SharePoint REST API
5 steps of how to add and use AutoMapper in .Net Core project
How to insert N strings of text to each row of the existing table