How to find out to which table the column name belongs to ?


How to find out to which table the column name belongs to ?

Ans:

SELECT TABLE_NAME=SYSOBJECTS.NAME,
COLUMN_NAME=SYSCOLUMNS.NAME,
DATATYPE=SYSTYPES.NAME,
LENGTH=SYSCOLUMNS.LENGTH
FROM SYSOBJECTS
JOIN SYSCOLUMNS ON SYSOBJECTS.ID = SYSCOLUMNS.ID
JOIN SYSTYPES ON SYSCOLUMNS.XTYPE=SYSTYPES.XTYPE
WHERE SYSOBJECTS.XTYPE=’U’
AND SYSCOLUMNS.NAME LIKE (‘COLUMNAME2FIND%’)
ORDER BY SYSOBJECTS.NAME,SYSCOLUMNS.COLID


--keep posting

Comments

Post a Comment

Popular posts from this blog

Fedora 32 Setting up Citrix workspace client

Installing and settingup citrix workspace on Fedora 32 in case you are facing issues with certificate error (SSL Error 61: You have not chosen to trust 'Certificate Authority) Download the latest version of citrix workspace app for linux form here https://www.citrix.com/en-au/downloads/workspace-app/linux/workspace-app-for-linux-latest.html Direct download lik -> https://downloads.citrix.com/17904/ICAClient-rhel-20.06.0.15-0.x86_64.rpm?__gda__=1594195198_18044945221df16b768c3db047809453 Open termial and navigate to `Downloads` folder and issue the command `sudo rpm -i ICAClient-rhel-13.10.0.20-0.x86_64.rpm` Download Server certificate -> (GoDaddy Secure Server Certificate (Intermediate Certificate) - G2) download .crt format  https://ssl-ccp.godaddy.com/repository/gdig2.crt Open up terminal and issue the command and navigate to `Downloads` folder and issue the command `sudo su` make the commandline as root user  followed by copying the certificate as admin use...
Read more

Probing element in app.config + Post build event to copy multiple files

Probing is quite good to arrange assemblies in case if you have lots of private libraries referred to your executables and which are there under a probing path mentioned under the probing element in app.config file When I started developing an executable , which demands to split its logic among several dlls and which are part of same solution and are deployed using simple xcopy method I found it quite convenent to use probing path combined with postbuild script under project properties section of the main executable file . Here in my example project, I have a dll project and an executable , which has been refered by the executable project in the same solution The following post-script build script save me from copying the required files into Binaries\Libs folder strcuture under the current selected build method(Release/Debug) . This is quite convenient in case to perform an xcopy of your binaries to the deployment folder. All the unwanted .vshost , pdb,manifest etc  files...
Read more

List of useful tools(Must have tools/Application)

 Snoop WPF (allows you to spy/browse the visual tree and change properties of a WPF UI) http://bit.ly/HgOHYc 7zip ( Zipping utility that supports number of different compression and extraction format 7zip,.tar,.zip,.rar,.bz etc:.) http://bit.ly/HQG6RC Free download manager(Accelerate downloading of files by using sliced download and support built-in bit-torrent protocol which can be enabled/disabled, once it is disables we cannot download using .torrent files) http://bit.ly/HgQ0ql Winmerge Compare and merge plain text files or directories . read more here  http://winmerge.org/ Libere office, replacement for MS Office  http://www.libreoffice.org/download/ Unstopcopy (Copies files from a source , can be useful if you would like to read corrupted files from your old VCD/CD/DVD)  http://bit.ly/HgRgti Sysinternals Suit (Complete set of tools required to master windows)  http://technet.microsoft.com/en-us/sysinternals/bb842062 Free English dictionar...
Read more