How to find dependencies between database tables in SQL Server 2012 -

-

i have blogging website has sql server 2012 on backend. building mobile app , post blogs directly backend.

i able insert post primary table, post not appearing on website.

i suspect there 1 or more tables contain additional data constituting blog post i'm unable find them.

is there efficient way find additional related tables? possible there "hidden" fields or tables in database?

first query give list of tables table references, , second give list of tables reference table. works if there referintial integrity set between tables.

declare @tablename  varchar(max) = 'mytable',         @schemaname varchar(max) = 'dbo'  select distinct        s.name schemaname,        o2.name tablename sys.foreign_keys fk join sys.objects o on fk.parent_object_id = o.object_id join sys.schemas s on o.schema_id = s.schema_id join sys.objects o2 on fk.referenced_object_id = o2.object_id join sys.schemas s2 on o2.schema_id = s2.schema_id o.name = @tablename       , s.name = @schemaname order schemaname,          tablename  select distinct        s.name schemaname,        o.name tablename sys.foreign_keys fk join sys.objects o on fk.parent_object_id = o.object_id join sys.schemas s on o.schema_id = s.schema_id join sys.objects o2 on fk.referenced_object_id = o2.object_id join sys.schemas s2 on o2.schema_id = s2.schema_id o2.name = @tablename       , s2.name = @schemaname order schemaname,          tablename

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more