T-SQL query to get the number of columns in a table

SELECT COUNT(COLUMN_NAME) 
FROM [ this_is_my_database_name].INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_CATALOG = ' this_is_my_database_name' 
AND TABLE_SCHEMA = 'dbo' --this is dbo by default, change if you need
AND TABLE_NAME = 'this_is_my_table_name'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s