Article for: SQL Server ▾ Query below lists all indexes in the database. Query select i.[name] as index_name, substring(column_names, 1, len(column_names)-1) as [columns], case when i.[type] = 1 then 'Clustered index' when i.[type] = 2 then 'Nonclustered unique index' when...
If you’ve forgotten the name of a specific table, or forgotten how to spell a table (was it plural or singular? One word or two with an underscore?), then you can use these queries to show all tables in your database. Each database vendor has a different way of showing tables. So...
This code recursively looks at every Stored Procedure in your Stored Procedure and gives you the full list of all tables used. declare @sp_name varchar(100) declare @curSpName varchar(100) declare @curObjName varchar(255) declare @curXType varchar(1) create table #tmpTables ( ...
Public Sub ListReportServersInDatabase(ByRef MachineNames() As String, _ ByRef InstanceNames() As String, ByRef InstallationIDs() As String, _ ByRef IsInitialized() As Boolean, ByRef Length As Int32, _ ByRef HRESULT As Int32, ByRef ExtendedErrors() As String) ...
I am looking for T-SQL code to list all tables in all databases in SQL Server (at least in SS2005 and SS2008; would be nice to also apply to SS2000). The catch, however, is that I would like a single result set. This precludes the otherwise excellent answer from...
In which we have one Manager DB and Each client has a Company DB. Now all of these database have the same Table Schema. But some of them have a missing Index on a certain Table. Is there a way to get a list of Databases with that missing index using SQL? We are using SQL-...
SELECT * FROM SYSTABLES; SYSTABLES is the DB2 standard catalog view. Where you find it depends on which flavor of DB2 server you are using: DB2 for i, LUW, or z/OS. You shouldn't need GO or other such fiddle-faddle. Right click on a statement in the SQL file editor, and yo...
each of our system catalog views we're using is scoped to the database level I strongly suggest that you run it from within the context of the database you're attempting to document. The first example below does just that, returning all columns for all user tables in the database....
To return all tablesandviews in one query, execute the following TSQL statement: SELECT *FROMINFORMATION_SCHEMA.TABLES; GO It may also be wise to specify the database you wish to query: SELECT *FROMdatabaseName.INFORMATION_SCHEMA.TABLES; ...
Append static csv column to result set on export of data; Using Select-Object and Export-CSV append string to all strings in array Appending info to the telephone (notes) tab in AD Appending line to info attribute with Powershell Appending Parent Folder, Current Folder onto file name Appending...