Tag Info

New answers tagged

1

If you are looking just for referenced tables name, this code will help SELECT o.name FROM sysobjects o WHERE EXISTS ( SELECT 1 FROM sysconstraints C JOIN sysreferences R ON R.constrid=C.constrid WHERE EXISTS ( SELECT 1 FROM sysobjects o2 WHERE o2.id=C.tableid AND o2.name ='tableName' ) AND R.reftabid=o.id )


0

Below is the script that I use --- master..sysdatabases& master..sysusages --- Source : http://benohead.com/sybase-size-of-data-and-log-segments-for-all-databases/ select db_name(d.dbid) as db_name, ceiling(sum(case when u.segmap != 4 then u.size/1048576.*@@maxpagesize end )) as data_size, ceiling(sum(case when u.segmap != 4 then size - ...


0

It's storing them inside project folder of MobiLink project as seperate files with mlt-extension. Format is XML.



Top 50 recent answers are included