i want table name basis on column name.

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / ravindra nhavi

5 Answers
8271 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i want table name basis on column name...

Answer / bobby

select * from information_schema.columns where
column_name='orderid'

The above query is used to find all the tables and views in
the Database which contain ‘orderId’ as column name.

But to find only the tables in the Database which
contain ‘orderId’ as column name, use the below query.

select col.table_name from information_schema.columns Col
join information_schema.tables Tab
on col.table_name=tab.table_name and
col.column_name='orderId'and tab.table_type='Base Table'

Is This Answer Correct ?

5 Yes

0 No

i want table name basis on column name...

Answer / saravanan p

Please find the below query in which, the tables are
selected depends the column name empNo.

select table_name from information_schema.columns where
column_name='empNo'

Is This Answer Correct ?

5 Yes

1 No

i want table name basis on column name...

Answer / debasis

yes . it's possible
create table emp10(emp10 varchar(20))

Is This Answer Correct ?

5 Yes

3 No

i want table name basis on column name...

Answer / gowthami radhakrishnan

yes.we can have a column name in the table name.
create table order
(
order varchar(10),
number int
)

Is This Answer Correct ?

2 Yes

2 No

i want table name basis on column name...

Answer / guruswamy

no,columnname and tablename not same to assign

Is This Answer Correct ?

0 Yes

6 No

Post New Answer