Keep Smiling Always
Home
About
Switcher
Thursday, 26 July 2012
Find Column Name in Database
Posted by
Sanjeet Kumar Satpathy
at
12:39
Labels:
Sql Server
0 comments
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE 'Date%'
ORDER BY schema_name, table_name
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Labels
Asp.net
(28)
C#
(1)
CSS
(2)
Entity Framework
(1)
HTML
(1)
Info Path
(1)
Javascript
(25)
LINQ
(3)
Oracle
(1)
Read
(1)
Sharepoint
(37)
Sql Server
(16)
TFS
(1)
WCF
(6)
Web Service
(1)
Blog Archive
►
2016
(1)
►
April
(1)
►
2015
(5)
►
December
(2)
►
February
(3)
►
2014
(6)
►
September
(1)
►
August
(1)
►
July
(2)
►
May
(1)
►
March
(1)
►
2013
(28)
►
November
(1)
►
October
(1)
►
September
(1)
►
July
(2)
►
June
(4)
►
May
(3)
►
April
(2)
►
March
(1)
►
February
(7)
►
January
(6)
▼
2012
(48)
►
December
(9)
►
November
(11)
►
October
(11)
►
September
(2)
▼
July
(1)
Find Column Name in Database
►
April
(5)
►
March
(2)
►
February
(3)
►
January
(4)
►
2011
(37)
►
December
(5)
►
November
(2)
►
October
(8)
►
September
(4)
►
August
(3)
►
July
(2)
►
May
(6)
►
April
(6)
►
March
(1)
Total Pageviews
Followers
Live Feedjit