Browse by Tags

All Tags » tsql » information schema (RSS)
Quick and simple way to know the stored procedures parameters using TSQL
Published 8 July 8 6:13 AM | SSQA.net
As you may be aware that you can pass parameters to the stored procedure when you have the selection of data requirement such as stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Using INFORMATION_SCHEMA...
Filed under: , , , , ,
TSQL to get clustered index information in SQL Server 2005
Published 10 March 8 3:0 AM | SSQA.net
Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index...
Filed under: , , , , , ,
Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?
Published 15 October 7 7:59 AM | SSQA.net
How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with...
Filed under: , , , , , , , ,
Getting table name from column name
Published 15 September 7 7:23 AM | SSQA.net
If you know the name of one column you want to find from which table that is originated, to retrieve the table name you can use following TSQL: SELECT CASE (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS AS c2 WHERE c2.TABLE_NAME = c1.TABLE_NAME AND...
Filed under: , , , , ,
TSQL methods to display the owner of schema in a database.
Published 15 August 7 4:23 AM | SSQA.net
You can use 2 methods to get information about owner of a particular schema or set of schema(s) within the database. Using INFORMATION_SCHEMA views method (which I prefer most of the times): USE <DBName> GO SELECT * FROM INFORMATION_SCHEMA.SCHEMATA...
Filed under: , , ,