Sureshkumar Ramakrishnan

  • Interests: Reading,Writing SQL queries

Technical Article

Retreiving all the Table Information from SQL

The Query will enable you to retrieve all the Tables in the Database .The Output of the Query will list all the User Tables along with the Column Names and the Sort order of the Columns .The Query will also return as to whether the Columns in the table are with allow null option or […]

You rated this post out of 5. Change rating

2006-07-06 (first published: )

436 reads

Technical Article

Retrieving all indexes of the Database.

The Script outputs all the indexes in the Database.I have used the sp_helpIndex system stored procedure here to retrieve all the indexes available for the Table . This is extremely useful in identifying all the indexes in a database in a single query

(2)

You rated this post out of 5. Change rating

2004-12-22 (first published: )

331 reads

Blogs

Plan your 2026

By

If you don't have a plan, you'll accomplish it. That's not a good thing.

Another Change

By

Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...

Using Prompt AI to Help Setup Data Analysis

By

I used Claude to build an application that loaded data for me. However, there...

Read the latest Blogs

Forums

Certificates expired - Can't restore after creating new certificate

By WebTechie

The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...

advice on diving into devops for managing BI projects

By stan

hi , i know this is a sql server forum but i think my...

Simplifying WHERE Condition with LIKE test on multiple columns

By Reh23

Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...

Visit the forum

Question of the Day

Which Table I

I have this code in SQL Server 2022:

CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    SELECT  ProductName
    FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

See possible answers