Skip to main content

List All The Column With Data Types in specific database

By
SELECT
OBJECT_NAME(c.OBJECT_ID) TableName
,c.name AS ColumnName
,SCHEMA_NAME(t.schema_id) AS SchemaName
,t.name AS TypeName
,c.max_length
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
ORDER BY c.OBJECT_ID;

Comments

Post a Comment

Popular posts from this blog

Basic SEO Explained: How Search Engines Really Work

By
Basic SEO Explained: How Search Engines Really Work Search Engine Optimization (SEO) is the process of improving your website so that it appears higher in search engine results pages (SERPs). SEO helps users find your content organically without paid ads and brings long-term traffic. If you are new to SEO, you should first read our complete on-page SEO guide for beginners to understand the basics clearly. How Search Engines Work (Step-by-Step) Search engines work in three main stages: crawling, indexing, and ranking. Understanding these steps is essential for building SEO-friendly websites. 1. Crawling Crawling is the process where search engines use bots (such as Googlebot) to discover new and updated pages. These bots follow links from one page to another across the web. Internal links help crawlers find your content faster. Learn more in our internal linking strategy guide . 2. Indexing After crawling, search engines analyze and store your pages in...
1 comment
Read more

What Is Web Hosting? A Beginner’s Complete Guide

By
What Is Web Hosting? A Beginner’s Complete Guide Web hosting is an essential service that allows websites to be accessible on the internet. Without web hosting, a website cannot be viewed online. What Is Web Hosting? Web hosting is a service that stores your website files on a server and delivers them to users when they visit your website. How Web Hosting Works When a user types your website address, the browser sends a request to the hosting server, which then displays your website files. Types of Web Hosting Shared Hosting: Affordable and beginner-friendly VPS Hosting: Better performance and control Dedicated Hosting: Full server access Cloud Hosting: Flexible and scalable Why Web Hosting Is Important Good hosting improves website speed, security, and uptime. Conclusion Web hosting is the foundation of every website. Beginners should start with shared hosting and upgrade as their site grows. Frequently Asked Questions Is web hosting necessary? Ye...
Post a Comment
Read more

How to Start a Blog Step by Step (Beginner Friendly)

By
How to Start a Blog Step by Step (Beginner Friendly) Starting a blog is an excellent way to share knowledge and build an online presence. With the right approach, anyone can start blogging. Choose a Blog Topic Select a topic you enjoy and can write about consistently. Select a Blogging Platform Popular platforms include Blogger and WordPress. Blogger is free and easy for beginners. Choose a Domain Name Your domain name should be simple, memorable, and related to your blog topic. Design Your Blog Use a clean, fast-loading theme that works well on mobile devices. Create Quality Content Focus on original, helpful, and easy-to-read content. Conclusion Blogging requires patience and consistency. With quality content, your blog can grow over time. Frequently Asked Questions Can I start a blog for free? Yes, platforms like Blogger allow free blogging.
Post a Comment
Read more