Sivaprasad S R

This SQL query retrieves all foreign key constraints that reference the table in the current SQL Server database.     SELECT * FROM sys . foreign_keys WHERE referenced_object_id = object_id ( ' <TABLE_NAME> ' )      This SQL query finds all foreign key constraints that reference the   table and generates SQL statements to drop them. SELECT 'ALTER TABLE [' + OBJECT_SCHEMA_NAME ( parent_object_id ) + '].[' + OBJECT_NAME ( parent_object_id ) + '] DROP CONSTRAINT [' + name + ']' FROM sys . foreign_keys WHERE referenced_object_id = object_id ( '<TABLE_NAME>' )

 Use the below sql script to generate c# model corresponding to the table.   Set @TableName to the name of your table.   declare @TableName sysname = 'TableName' declare @Result varchar (max) = 'public class ' + @TableName + '{' select @Result = @Result + ' public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }' from ( select replace(col.name, ' ' , '_' ) ColumnName, column_id ColumnId, case typ.name when 'bigint' then 'long' when 'binary' then 'byte[]' when 'bit' then 'bool' when 'char' then 'string' when 'date' then 'DateTime' when 'datetime' then 'DateTime' when 'datetime2' then 'DateTime' when 'datetim...

First you need grand  permission Ole Automation Procedures to your server. This can be achived by executing the below sql script sp_configure 'show advanced options', 1  RECONFIGURE; sp_configure 'Ole Automation Procedures', 1  RECONFIGURE;  sp_configure 'show advanced options', 1 RECONFIGURE;  Then the next step is to call a web call. create FUNCTION dbo.WebRequest(@parm VARCHAR(20)) RETURNS VARCHAR(250) AS BEGIN  DECLARE @parmVARCHAR(20)  SET @parm= @parm Declare @Object as Int; Declare @ResponseText as Varchar(8000); Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT; Exec sp_OAMethod @Object, 'open', NULL, 'get', http://www.your.api.call.here', --Your Web Service Url (invoked) 'false' Exec sp_OAMethod @Object, 'send' Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT --Select @ResponseText Exec sp_OADestroy @Object     RETURN @ResponseText END replace the http://www.your.api.call....

--Get the list of all the tables to be truncated   DECLARE @TablesToBeTruncated AS TABLE   (Id INT IDENTITY(1,1),TableObjectId INT , TableName SYSNAME,      SchemaId INT ) INSERT INTO @TablesToBeTruncated   SELECT ST.object_id,ST. name ,ST.schema_id   FROM sys.Tables ST   WHERE ST.type = 'U' AND ST. NAME NOT LIKE '#%'   AND ST. name <> 'sysdiagrams'   --AND ST.NAME NOT IN ('') -- Specify here the comma separated table names for which truncation is not required   --AND ST.NAME IN ('') -- Specify here the comma separated table names which needs to be truncated     --Generate the foreignkeys drop and create back script DECLARE @CreateScript AS NVARCHAR( MAX ), @DropScript AS NVARCHAR( MAX ) SELECT      ------------DROP SCRIPT--------------------      @DropScript = ISNULL (@DropScript, '' ) + 'ALTER TABLE ' + QUOTENAME(SCHE...